I have a encrypted column in a table. The fulltext search is not working on this column.
My query is like below,
SELECT * FROM NAMETABLE WHERE Freetext(BriefProfile , '"williams"');
--where BriefProfile column is Encrypted column.
--My query with LIKE OPERATOR is something like below
OPEN SYMMETRIC KEY brief_skey
DECRYPTION BY CERTIFICATE brief_certificate;
SELECT * FROM NAMETABLE WHERE CONVERT(varchar(5000), DecryptByKey(BriefProfile)) like '%williams%';
How can we perform a fulltext search on the above encrypted column?
Thanks in advance