encrypt - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

encrypt

Author

Topic

Gordon.Davis
Starting Member

4 Posts

Posted - 2011-09-28 : 13:52:29

HI Everyone,

for the below statement when i put like its not coming..AddressLine1 is Encrypted value.
SELECT * FROM table
WHERE AddressLine1 LIKE '%0x00DF6388C7725BD29E51CC0069D10B69010000007D6328DBDA07A9645D71889BA997A7E465A03213C73DDC9E952D9D233B3C72BFCA645CBD11A0B11115BFA2D8B0BE2BD39532D0F1701AD33EB096F7D4AC338B5375D9C06AF2420563FC03A2DAF9019C9A5D385AE10B259DA9E75BAEF4D3E732C8D180743C783243CE%'

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-28 : 14:33:05

i think you should apply same encryption key to decrypt and then use value for searching

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources