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: [email protected] [mailto:[email protected]] On Behalf Of IT-Laure Hansen Sent: Wednesday, September 16, 2009 7:58 PM To: '[email protected]' 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: [email protected] <[email protected]> To: U2 Users List <[email protected]> Sent: Wed Sep 16 17:54:12 2009 Subject: Re: [U2] Null character causes odd UV behaviour > -----Original Message----- > From: [email protected] > [mailto:[email protected]] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
