DecryptByPassphrase where key has single apostrophe

• i.campbell 84312

  SSC Veteran

  Points: 235

  More actions

  February 20, 2019 at 2:13 am

  #381481

  Hi All,
  i wonder if anyone has an example of a decryptbypassphrase where the key (in this case a varchar parameter) has an apostrophe?
  see below for my example:
  SELECT cast(DecryptByPassphrase(''' + @uncryptpassword + ''',dbo.tblx.eePassword) as varchar(32)) as eePassword,  
  FROM dbo.tblx
  @uncryptpassword is set to ABC123'

  the select works for all other entries where an apostrophe is not set.

  thanks in advance

• i.campbell 84312

  SSC Veteran

  Points: 235

  More actions

  February 20, 2019 at 3:19 am

  #2022462

  ok, managed to get this working by doing a replace on the parameter to replace ' with ''