Click here to Skip to main content
14,454,890 members
Rate this:
Please Sign up or sign in to vote.
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 13-Feb-20 0:44am

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

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.
   
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100