Hi Dikong42,
One possible way could be that you replace the special characters from your column values before comparing against the user input string. Something like below:
SELECT * FROM TableName
WHERE REPLACE(REPLACE(StringColumnName,'-',''),'/','') = 'UserInputString'
Please note that if the special character is making the value unique then you will have multiple rows returned, however I assume your column's selectivity is not dependent on these special characters.
HTH,
Cheers!!
Ashish
Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.
