David Higgs
Programmer
I have suspected for sometime that a Database of mine has some "hidden" issues.
When I searched for e.g "A1ABC" I found 11 Records and when I searched for "A1ABC " I only found 4 Records. I found the 4 Records were showing a LEN = 6 and that the 6th CHR was a ascii CHR 160 (non-breaking space).
The FIELD Type = CHARACTER and the Width = 12. The actual Length can vary between 4 to 12 Characters and there are 20700 Records.
What would be the easiest way to remove the ascii CHR 160
Regards,
David
When I searched for e.g "A1ABC" I found 11 Records and when I searched for "A1ABC " I only found 4 Records. I found the 4 Records were showing a LEN = 6 and that the 6th CHR was a ascii CHR 160 (non-breaking space).
The FIELD Type = CHARACTER and the Width = 12. The actual Length can vary between 4 to 12 Characters and there are 20700 Records.
What would be the easiest way to remove the ascii CHR 160
Regards,
David