Escape single quote from password

• radica_pet

  SSC Enthusiast

  Points: 121

  More actions

  September 17, 2009 at 6:15 am

  #214576

  Hi!

  I have a problem with escaping single quote on creating login user.

  Is there some store procedure that can automatically escape single quote?

  Thanks

• Seth Lynch

  SSCrazy

  Points: 2975

  More actions

  September 17, 2009 at 9:37 am

  #1055076

  If you create the password using a stored procedure and pass it in as a parameter you shouldn't need to escape it.

  If not you can check for ' in the password and escape it by using another one ''