techjohnny
Member
We recently used a tool to automatically update a field, unfortunately the person used copy and paste to update a description field for several thousand items. Now the description field has a character which is a return character that is showing up as a square in our application.
Now whenever we try and view any reports in Crystal that contain this character it reports an invalid hexadecimal character.
I want to run a query against the database that will display all items with this character in the description, so can somebody help?
Update: I run this query using Procedure Editor "select PartDescription from Part where partnum = ".002 3M TAPE" it returns:
** Invalid character unit value 1001, Changed to 320 (4132)
** FILL-IN Description will not fit in FRAME in PROGRAM. (4028)
Thanks.
Now whenever we try and view any reports in Crystal that contain this character it reports an invalid hexadecimal character.
I want to run a query against the database that will display all items with this character in the description, so can somebody help?
Update: I run this query using Procedure Editor "select PartDescription from Part where partnum = ".002 3M TAPE" it returns:
** Invalid character unit value 1001, Changed to 320 (4132)
** FILL-IN Description will not fit in FRAME in PROGRAM. (4028)
Thanks.
Last edited: