Hi All
I am trying to find if there is any special characters hidden inside a string. I need to know what are they so that I can action/replace them!
Example: I have a table "Test" with 2 columns "Name1" and "Name2" with following values.
| Name1 | Name2 |
|---|
| DAVID | DAVID |
| TONY D'SUZA | TONY D'SUZA |
| MARRY | NANCY |
When I run a query like this:
select name1, name2 from test
where name1 = name2
It should return row 1 and row 2 which it doesn't at the moment. I have tried with trim but couldn't find out what's wrong. Also searched if there is any line feed / chr(10) / chr(12) / chr(13). Nothing is there.
// Need to mention here that, the data is inserted into this table through a csv file. Not all records are like this, but there are some which are not returning in my above query.
This forum always shows some light to me. If anybody knows the issue, please share your knowledge.
Thanks in advance for all your help.