I have an email as follows:
[email protected]
Now when i make a call and pass it as a parameter i do the following
HttpUtility.UrlEncode(email) in order to get the + sign.
But when i receive the email in the procedure , it is now
test+user1%40test.com
I have tried HttpUtility.UrlEncode, but i no longer have the @ sign
and when i try to search my table , it cant find it.
My search is as follows:
" SELECT ......... where Email like '%' + @Email + '%' ";
So how can i get it back to [email protected] ?