Using "LIKE" to determine the contents of a variable

Question

4.00/5 (1 vote)

See more:

HI
My problem is as follows. I have a table that has an "ID" field with id's that begin with "ST" and "#STA". I want to save the ID field in a variable and then "IF" it begins with "ST" i want to run a stored procedure else if it begins with "#STA" i want to run a different stored procedure. How do i accomplish this??

I tried to do it the following way:

@id := "either ST or #STA"

IF @id LIKE "#STA"
THEN
"DO SOMETHING"
END IF

Im a bit lost, can someone help?

Posted 7-Jan-13 7:21am

Ashy-G

Add a Solution

Comments

Jibesh 7-Jan-13 13:46pm

Are you using a stored procedure?

Ashy-G 8-Jan-13 7:52am

yes

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)

André Kraak · Answer 1 · 2013-01-07T07:58:00

When using LIKE[^] is the situation you describe you need to use the '%' wildcard.
If a string should start with a particular pattern (in your case "#STA") add the wildcard '%' to the end of the pattern. The wildcard '%' stands for any string of zero or more characters.

So use

SQL

IF @id LIKE "#STA%"

and any string that begins with "#STA" would mean "DO SOMETHING" is executed.