What is wrong with this statement

• ramadesai108

  SSChampion

  Points: 10609

  More actions

  March 13, 2009 at 6:30 am

  #200958

  Hi All,

  What is wrong with this statement. Even when CHARINDEX is zero it goes thru the 2nd case statement:

  CASE WHEN CHARINDEX('-',ClientID) <> 0 THEN

  (CASE WHEN ISNUMERIC(SUBSTRING(ClientID,CHARINDEX('-',ClientID) + 1, 5)) = 1

  THEN CONVERT(INT,SUBSTRING(ClientID,CHARINDEX('-',vchClientSubSessionID) + 1, 5))

  ELSE ClientID END)

  ELSE ClientID END

  Thanks.

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  March 13, 2009 at 6:44 am

  #959040

  Duplicate post - refer to this link

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot