Sql – How to use LIKE condition in SQL with numeric field


I'm using this query to get some specific data: "select * from emp where emp_name LIKE 's%'";

emp_nam is character field, how can I use the same logic condition with numeric field? something like:

"select * from emp where emp_id ????

where emp_id is numeric field.


Best Solution

You can't do a wildcard on a number, however, if you really need to, you can convert the number to a varchar and then perform the wildcard match.


SELECT * FROM emp WHERE CONVERT(varchar(20), emp_id) LIKE '1%'