I have a text column that has numbers with spaces interleaved (example 8
1234 5678 9). I am trying to strip the spaces so that I end up with the
following 8123456789 (all of the numbers without spaces).
I tried to accomplish this by using the following function:
Update FINN set UPC_TXT = (sstrip(upc_txt,(char(032))))
I have also tried:
Update FINN set UPC_TXT = (sstrip(upc_txt,' '))
This does not work either:
set var vTEST text = (sstrip('8 1234 5678 9',(char(032)))). the result is 8
1234 5678 9
Any ideas what I am doing wrong.
John Engwer
Engwer & Associates
2449 Scenic Ridge Drive
North Huntingdon, PA 15642-2120
Phone: 412 751-2433
Email: <mailto:[email protected]> [email protected]
<http://www.ENGWER.US> WWW.ENGWER.US
