How to handle name with 's

• tonyarp05 61903

  SSCommitted

  Points: 1515

  More actions

  April 27, 2012 at 12:25 am

  #259990

  Hi,

  declare @test-2 varchar(100)

  set @test-2 = 'kathy''s'' side'

  select @test-2

  Output :

  kathy's' side

  How to get the name like -' Kathy's side ' - with single 's, or how to handle this name with sql server query

  Could you please help me on this.

  Thanks,

  Tony

• imex

  Ten Centuries

  Points: 1234

  More actions

  April 27, 2012 at 12:29 am

  #1480200

  Hi,

  Try:

  set @test-2 = 'kathy''s side'

  Hope this helps.

  https://www.imoveisemexposicao.com.br/imobiliarias-em-guarulhos

• vinu512

  SSCoach

  Points: 15729

  More actions

  April 27, 2012 at 12:44 am

  #1480209

  +1 imex

  Vinu Vijayan

  For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉