LIKE Condition with multiple values

Question

question

Bala asked Jan 6, '10

LIKE Condition with multiple values

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

like search

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-01-06T22:10:27Z

Scot Hauder answered Jan 6, '10

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%' :)

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-01-06T13:17:59Z

Bala answered Jan 6, '10

never mind...Got it. i dont know why i asked this !!!

2

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ · Jan 06, 2010 at 01:40 PM

Post the answer so someone else reading it knows what you did.

5 ·

Håkan Winther · Jan 06, 2010 at 06:05 PM

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

0 ·

Answer 3 · 2010-01-07T17:38:37Z

zira answered Jan 7, '10

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.

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question