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
sl.no data
1 ABC
2 FGH

This data needs to be searched in another table as C containing data
sl.no 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
Posted
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
 
Comments
TheRealSteveJudge 13-Feb-20 3:22am    
5*
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