How to use different like operator in where clause,

Question

0.00/5 (No votes)

See more:

I am writing a query with like operator in where clause. i need different like operator in where clause.

suppose UniversityName Column contain a string '

UU3-UU8-UU14-UU18-UU23-UU24-UU45-UU74

'

i don't want to use OR operator. so i want to use In Operator. but it not working.

What I have tried:

Select * From MasterCustomer where UniversityName Like'%UU1%'

Select * From MasterCustomer where UniversityName In (Like'UU1', Like'UU1-%', Like'%-UU1', Like'%-UU1-%')

Posted 6-Mar-17 2:34am

kantagrawal

Updated 6-Mar-17 2:45am

Add a Solution

Comments

Bryian Tan 6-Mar-17 9:55am

What wrong with Like'%UU1%'?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-03-06T02:45:00

It depends what you are trying to do: the second "what I have tried" syntax will not work at all (and none of the LIKE sequences would match your example).

But the first one:

SQL

...WHERE UniversityName LIKE '%UU1%'

should work, as it will match your example several times: UU14 and UU18. The "%" is a wildcard, meaning "any number of any characters", similar to the "*" in windows filenames, so '%UU1% matches any input string that contains UU1 in any location.

I suspect that you need to take another look at your data, as I suspect the UniversityName column does not contain "UU3-UU8-UU14-UU18-UU23-UU24-UU45-UU74" (or is has completely the wrong column name for the content it does have).