Finding Comma in the string

• farooq.hbs

  SSCrazy

  Points: 2083

  More actions

  March 18, 2013 at 1:24 am

  #394409

  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.

• farooq.hbs

  SSCrazy

  Points: 2083

  More actions

  March 18, 2013 at 1:45 am

  #1597973

  I got the solution..

  CHARINDEX(',' ,@string) > 0

  Thanks

  Farooqh