Problem in stored procedure

Question

3.00/5 (1 vote)

See more:

, +

How to use multiple like operater in stored procedure..?

select Name,Experience,ExpMonth,ug,PreferredRole,Skill,CountryOfResidance,Name,Gender,JobCategories,PresentDesignation,Skill,PreferredRole,PrefferdJobLocation from Candidate_Registration where PresentJobLocation like 'C%'

waned to use another like operter and OR operator in the same query..

Posted 12-Feb-14 18:22pm

RajeeshMenoth

Add a Solution

3 solutions

Solution 1

Multiple like operator example:
Refer:
http://stackoverflow.com/questions/1387612/how-can-i-introduce-multiple-conditions-in-like-operator[^]
This may help.

Posted 12-Feb-14 18:25pm

Gitanjali Singh

Comments

[no name] 13-Feb-14 0:37am

I wanted to use or operator in the same program

Add a Solution

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

JoCodes · Accepted Answer · 2014-02-12T18:34:00

Solution 3

Refer

sql-server-2005-using-or-operator-with-like-operator[^]

Posted 12-Feb-14 18:34pm

JoCodes

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-02-12T18:26:00

Solution 2

SQL

select Name,Experience,ExpMonth,ug,PreferredRole,Skill,CountryOfResidance,Name,Gender,JobCategories,PresentDesignation,Skill,PreferredRole,PrefferdJobLocation from Candidate_Registration where PresentJobLocation like 'C%' OR SomeOtherColumn like 'someValue%'

Posted 12-Feb-14 18:26pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Updated 12-Feb-14 18:27pm

v2

Comments

[no name] 13-Feb-14 1:34am

Thank u..one more problem i have same column name and different parameter name..each parameter will initialize with same column name using OR and like operator it is possible or not?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Feb-14 1:53am

Yes, possible like...

select Name,Experience,ExpMonth,ug,PreferredRole,Skill,CountryOfResidance,Name,Gender,JobCategories,PresentDesignation,Skill,PreferredRole,PrefferdJobLocation from Candidate_Registration where PresentJobLocation like 'C%' OR PresentJobLocation like 'someValue%'

[no name] 13-Feb-14 2:02am

am using 4 checkbox like delhi,chennai,kochi,banglore when i click thiz checkbox the particular stord procedure vl work but i was clicked two checkbox like delhi and chennai but no value vl formed..

Problem in stored procedure

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Problem in stored procedure

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us