Hi How can i retrieve information based on multiple wildcard conditions? For example, I need list of customers with names beginning either with A or CU or TO?
A little lost...
I think Bala realized the answer after typing the end of the question: ...A or CU or TO
Name like 'A%' or Name like 'CU%' or Name like 'TO%' :)
never mind...Got it. i dont know why i asked this !!!
In like condition you can use regular expression characters such as ^ and ~ along with usual %. It works with SQL 2005 and 2008. I am not sure about 2000.
No one has followed this question yet.