I think if you looked at the hex values of Char(128) you would see two characters. Convert will only change one character for another (same size). Swap will change characters of any size to characters of any size.
SWAP CHAR(128) WITH "" IN STATE should work if I remember right. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Wednesday, September 16, 2009 7:58 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Null character causes odd UV behaviour Indeed. I'd call IBM or my VAR if I were you. And thanks for the mention! Laure Hansen, City of Redwood City I.T. Tel: 650-780-7087 Cell: 650-207-3235 ----- Original Message ----- From: u2-users-boun...@listserver.u2ug.org <u2-users-boun...@listserver.u2ug.org> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Wed Sep 16 17:54:12 2009 Subject: Re: [U2] Null character causes odd UV behaviour > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, > Rodney A (Rod) 46K > Sent: Wednesday, September 16, 2009 5:16 PM > To: U2 Users List > Subject: Re: [U2] Null character causes odd UV behaviour > > Try SWAP instead of CONVERT. I can't find any UV documentation on the syntax for SWAP, and it what I tried wouldn't compile, but it looks like UV BASIC just can't see the null character as a character. Thanks to a suggestion from Laure Hansen I tried writing the value out to a file, and it is definitely character 128: Top. ----: P 0001: ^128 Bottom at line 1. I was able to work around it with: IF LEN(STATE) = 0 THEN STATE = '' Seems like a bug to me, though. Thanks, John _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users