Loading

How to find a variable in name without using like operator in sql server

magesh manavalan

14y2k

how to find a variable in name without using like operator in sql server?

Please Send me Sample Query.

Thanks&Regs

Manavalan.A

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Hi,

You can do by creating Full text index. Then it can be queried using the contains or containstable.
0
Satyapriya Nayak14y ago
Hi Magesh,

Please refer the below link

http://www.stuffthatjustworks.com/HowToSearchSQLForKeywordsWithoutLIKE.aspx

Thanks
0