jdr0606
asked on
Locate hidden characters in a MSSQL field
In our inventory master table it looks like we have some duplicate item numbers but they are in fact different because one has invalid hidden characters at the end of the visible item number.
How can I display the hex representation of the item number so that I know what to correct?
How can I display the hex representation of the item number so that I know what to correct?
Downloadeth a free trial of UltraEdit, File:Open and open a flat file that contains your data (copy-paste might work too), hit Control-H, and bammo now you can see Hex characters and their ANSI codes.
ASKER
I can do that but was hoping to do something in SQL since I may need to look at thousands of items for potential issues.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.