[RBG7-L] - Re: Null character

[Bernard Lis]

Joel, try setting -0- text to null update tablename set colname = null where colname='-0-'   Bernie Lis ----- Original Message ----- From: Joel Solomon To: RBG7-L Mailing List Sent: Friday, August 06, 2004 4:44 PM Subject: [RBG7-L] - Null character I know its late on Friday, but this is really got me stumped.   I have data that looks like a null (-0-) but does not act like a null.   In some of my fields the null appears and when I set null to a blank the field is blank (works correctly).  But, in other fields the field has a -0- that does not act as a null.  It left justifies itself and is recognizable as a null.   The only difference is that the data with the funny null came from a laptop computer and the data was later appended to the master table.  Both were entered into a form.   Am I going crazy??   Joel Solomon Controller Barbizon International [EMAIL PROTECTED] Ph:    954-345-4140  ext. 203 Fax:   954-345-8055