Click here to Skip to main content
15,882,388 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have data in my table as A data

This data needs to be searched in another table as C containing data data
1 a-bc
2 f/gh
3 ab-c.

I Need this data by ignoring "-, /" special character.

What I have tried:

Please help me to get the data using SQL queries
Updated 12-Feb-20 23:44pm

1 solution

You could repeadtly apply the REPLACE[^] function to the C table in order to remove the unwanted special characters and then compare it with table A.
Share this answer
TheRealSteveJudge 13-Feb-20 3:22am    
CPallini 13-Feb-20 3:24am    
Thank you.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900