John, NULL works fine as a parameter in SRPL:: (SRPL(upc_txt,' ',NULL,0))
Bill On Wed, Feb 11, 2009 at 3:03 PM, John Engwer <[email protected]> wrote: > 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: [email protected] > > WWW.ENGWER.US <http://www.ENGWER.US> >
