sql2005 - Wildcard search on encrypted column?
In Sql2005, is it possible to perform a wildcard search on an encrypted column?
Many thanks!
[109 byte] By [jfisher] at [2007-11-20 7:53:23] 
Hi:
In Sql2005, is it possible to perform a wildcard search on an encrypted column?
Many thanks!
# 1 Re: sql2005 - Wildcard search on encrypted column?
You should be able to use wild cards, cast the return value of DecryptByPassphrase or DecryptByCert functions to nvarchar and compare the value with the pattern using like.hspc at 2007-11-9 13:45:10 >
