LIKE usage

[gabigeo]

Hi,

I am doing this query succesfully in MySQL and I wonder why the LIKE does not work the same in MSSQL. Is there any way arround?

MySQL: SELECT * FROM tariffs WHERE '4321' LIKE concat(prefix,'%')

MSSQL: SELECT * FROM tariffs WHERE '4321' LIKE (prefix + '%')

the MSSQL query returns NULL always.
The long workarround is to make a: WHERE prefix = '4321' OR prefix = '432' OR prefix = '43' OR prefix = '4'
but I want to avoid this.

Anybody knows a workaround?

Thanks

[gabigeo]

Ok, I found the solution.
Using RTRIM like this it works:

SELECT * FROM tariffs WHERE '4321' LIKE RTRIM(prefix) + '%'

[ck9663]

Ok, I found the solution.
Using RTRIM like this it works:

SELECT * FROM tariffs WHERE '4321' LIKE RTRIM(prefix) + '%'

Your where clause:

WHERE prefix = '4321' OR prefix = '432' OR prefix = '43' OR prefix = '4'
 

is similar to

WHERE PREFIX like '4%'

-- CK