How to select with N like
I have a problem with my project when work with MSSQL, like this:
TableName: tbA Colums: X (int-primarykey) , Z(string) 1 | 'abc' 2 | 'azc'
3 | 'xyz' 4 | '123' ...
Proceduce: pSearch(@input string)
I want to select tbA combines LIKE and IN with ideal:
SELECT * FROM tbA a WHERE a.Z IN ('"a%c" OR "x%"')
something like it, and maybe I have a solution that's full-text search but
I don't want to use it.
I hope people give me a solution or something else, thanks all.
No comments:
Post a Comment