Category: SQL Server

20 Oct 2016 08:06

Joined:	06/06/2011
Level:	Gold
Points:	1173

Points:	3

How to split commas in where condition

Column1. Column2
Row1 value1
Row2. Value2,value1
Row3 value1, value3,value2

Hi,

I need to achieve a sql query.
Condition1 : Column2 should come in 'where' condition'.
Condition2 : In case of two or three or more value(with splitted by commas), it should automatically come in 'where' condition divided by 'or'

Example:

select * from tablenamr where (case when column1=row3
Then column2=value1 or column2=value3 or column2=value2)

#768138

20 Oct 2016 12:59

Joined:	06/06/2011
Level:	Gold
Points:	1173

Points:	1

string a= "monday,tuesday,thursday"

Now, I am passing this value to a stored procedure as a string. I want to fire query like:
Select *
from tablename
where days = 'monday' or days = 'tuesday' or days = 'thursday'`

#768139

20 Oct 2016 14:04

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	3

Hi Lily,

Why not we can use IN Clause for your problem. Because instead of OR, IN clause also gave the same result for your problem.


Select * from Tablename where days IN ('monday','tuesday','wednesday')

So if any one is true in the list your select query will be displayed.

Kindly write the query with IN clause and check in SQL Server whether you are getting the same result as you are expecting.

Thanks,
Mani

How to split commas in where condition

About dotnetspider.com

Quick Links

General

Services