Use the like operator with the parameter

Ali408

Hi

I want to use the Like operator. How is this done?

for example:
SELECT * FROM T1 WHERE Id LIKE N'%@ID%'

This code does not show anything

help me please, Thanks

ipong

try

SELECT * FROM T1 WHERE Id LIKE '%' & @ID & '%'

note: msaccess database

Ali408

Thank you

Your code was correct and only needed a small change.
Instead of & should be + used.

SELECT * FROM T1 WHERE Id LIKE '%' + @ID + '%'