Link to home
Start Free TrialLog in
Avatar of jdr0606
jdr0606Flag for United States of America

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?
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

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.
Avatar of jdr0606

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
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial