Question encrypting or derypting the values

[svibuk]

i have a stored procedure to make a column encrypted using symmetric key & certificate in SQL

i have encrypted data in sql table

i need to compare / check this data value in windows forms with the user input & accordingly execute further.

how do i compare the encrypted data value with normal user value . so either i need to decrypyt the existing db value or encryppt the user value

how can it be done