Like funtion

[sc5502]

I have a table that is still SQL 2005. This table has a field defined as an int

RECD_NUMBER	int

I want to perform a search on that field using the Like function.

SELECT *
FROM [myDatabase].[dbo].[myTable]
WHERE recd_number LIKE %2548%

This does not not work. Any ideas? Thanks.

[Rabbit]

The LIKE operator only works on strings, you'll need to convert both sides of the operands to strings