InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:37:41 GMT20http://www.sqlservercentral.com/Forums/Topic1366346-1292-1.aspxWith blanks?SQL ignores trailing spaces when comparing strings. Just make sure that the char length is longer than the string you're converting.Mon, 01 Oct 2012 02:04:52 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1366346-1292-1.aspxThanks!did the trick even without lengt for char.I wonder a bit - 070564-2869 - has 11 characters, but should i use 'With blanks'?Best regardsEdvard KorsbækMon, 01 Oct 2012 01:57:08 GMTedvard 19773http://www.sqlservercentral.com/Forums/Topic1366346-1292-1.aspxI think you've got that query the wrong way around. You're comparing the encrypted column with the results of the decryption function. You should be comparing the decrypted value with the results of the decryption function applied to the column.Also, you're not specifying a length for char, you should. do you know what the default is?Something roughly like this[code="sql"]select COUNT(*) from dbo.personal where Convert(Char[<whatever the string length is>,DecryptByPassPhrase('[PASSPHRASE]',CPR_encrypted)) = '070564-2869'[/code]Mon, 01 Oct 2012 01:50:16 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1366346-1292-1.aspxThis query returns a lot of results:select Convert(Char,DecryptByPassPhrase('[PASSPHRASE]',cpr_encrypted)) from dbo.personal I have changed the actual passphrase to [PASSPHRASE] above.one of the results is:'070564-2869 'Without the quotation marks, but there is a lot of blanks in it. the field is defined as cpr_encrypted varbinary(256)Then i use this to find it again:select COUNT(*) from dbo.personal where CPR_encrypted = Convert(Char,DecryptByPassPhrase('[PASSPHRASE]','070564-2869 '))Which returns zero (nul NULL, zero)What am i doing wrong?Best regardsEdvard KorsbækMon, 01 Oct 2012 01:37:27 GMTedvard 19773