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...
Thanks
asked
LIKE Condition with multiple values
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 !!!
One of the main purposes of sites like this is knowledge sharing, and that is why you should post the answer even if you find it yourself
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.
