Using CASE select in a stored procedure

• Anthony Phillips-301303

  Mr or Mrs. 500

  Points: 574

  More actions

  May 4, 2006 at 7:11 am

  #168123

  Hey guys. Does anyone know how I can use case select in a stored procedure to check for multiple criteria in a table? Here is an example of what I'm trying to do.

  CASE ClientBoxNumber WHEN '0096028'  OR '0096076' THEN '0096064' END

  What is the correct syntax?

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  May 4, 2006 at 7:48 am

  #635921

  (CASE

  WHEN CLIENTBOXNUMBER IN ('0096028', '0096076') THEN '0096064'

  ELSE ''

  END)

   

• Riyaz Ghouse

  SSC-Addicted

  Points: 464

  More actions

  May 4, 2006 at 6:21 pm

  #636120

  rharma...was spot on...but just wanna make things perfect...

  SELECT CASE WHEN CLIENTBOXNUMBER IN ('0096028', '0096076')

                      THEN  '0096064'

   

• Riyaz Ghouse

  SSC-Addicted

  Points: 464

  More actions

  May 4, 2006 at 6:23 pm

  #636121

  sorry mate pblm with backspace in my keyboard

  SELECT CASE WHEN CLIENTBOXNUMBER IN ('0096028', '0096076')

                      THEN  '0096064'

                       ELSE

              END  as 'ColumnName'

  FROM    TableName

   

• Anthony Phillips-301303

  Mr or Mrs. 500

  Points: 574

  More actions

  May 6, 2006 at 5:03 am

  #636406

  Thanks guys!