Guys,
Declare @string VARCHAR(MAX)
SET @string IN ('sql','server','2008')
Here, How to find a comma in the above string?
whether comma(,) exists or it is single value
I want to solve the below example
SELECT CASE WHEN @string = 'some string' THEN 'XYZ'
WHEN @string IN (,) THEN 'abc' ---- the will be comma separated multiple value('sql','server','2008')
FROM my_table
If comma exist in the string then i want to print value.