Lookin For an Escape

• jwt

  Say Hey Kid

  Points: 668

  More actions

  July 22, 2003 at 6:35 am

  #80538

  This one is embarassing, but I can't get it figured out, so I am asking for help.

  I am trying to pass a query to a string, and I want to use Like in the WHERE clause. But I don't know how to pass in the single quote marks.

  eg

  @sqlquery = 'SELECT ErrorMsg FROM ErrorTable WHERE ErrorMsg LIKE 'Critical%' '

  Can anyone help?

  Thanks

  Jeff

  Edited by - jwt on 07/22/2003 07:08:01 AM

  Edited by - jwt on 07/22/2003 07:09:11 AM

• Ritch

  Ten Centuries

  Points: 1044

  More actions

  July 22, 2003 at 6:43 am

  #466369

  Here you go

  @sqlquery = 'SELECT ErrorMsg FROM ErrorTable WHERE ErrorMsg LIKE ' + '''Critical%'''

  Laters

  *I didn't do anything it just got complicated*

  
  "I didn't do anything it just got complicated" - M Edwards

• jwt

  Say Hey Kid

  Points: 668

  More actions

  July 22, 2003 at 7:07 am

  #466383

  Thanks!

  BTW is that one double and one single quote around critical, or is it three singles?

• Ritch

  Ten Centuries

  Points: 1044

  More actions

  July 22, 2003 at 7:09 am

  #466384

  Hi,

  Sorry wasn't very readable was it. Three singles each side.

  Laters

  *I didn't do anything it just got complicated*

  
  "I didn't do anything it just got complicated" - M Edwards

• jwt

  Say Hey Kid

  Points: 668

  More actions

  July 22, 2003 at 7:20 am

  #466387

  This was what I was doing - only I was trying to do it all in one string rather than using the concatination of the string with the escape characters....

  So now I know - and knowing is half the battle.

• EdH334

  SSCrazy

  Points: 2857

  More actions

  July 23, 2003 at 1:52 am

  #466525

  You can do it all in one - just put two single quotes instead of one. e.g.

  @sqlquery = 'SELECT ErrorMsg FROM ErrorTable WHERE ErrorMsg LIKE ''Critical%'' '