If you are trying to see if the value is null, try @NULL. Brenda L Price UniVerse Programmer Rapid Response Team Market America, Inc. Greensboro, NC
> -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of John Hester > Sent: Wednesday, September 16, 2009 8:54 PM > To: U2 Users List > 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
