ms access - How to use LIKE condition in SQL with numeric field?

Question

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.

Thanks,

Answer 1

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.

eg.

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