use the ISNULL() function Nadir Ait-Laoussine <[EMAIL PROTECTED]> wrote: In the past, when I ran into this problem and had to do something about it, I just through in an "�" it creats a space, not visible. It's just a quick fix until you can find a better solution. Nadir -----Original Message----- From: j p [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 3:01 PM To: CF-Talk Subject: Urgent Help needed! I have never had a problem inserting null values into a db table that accepted null values before this. This below data chokes at the first NON-text blamk comma. The rub - it's a money field (SQL 7) and I can't use ''. Any ideas... 'Alda','Update','','ALDA','','',132860.0,0.48,0.45,0.45,0.46,63086.0,87.0,,, ,,,,,2000-01-01 00:00:00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,190 0-01-01 00:00:00,,,,,,,,,,,,,,,,,,,,,,,,,,,,1900-01-01 00:00:00,,,,1900-01-01 00:00:00,,,,1900-01-01 00:00:00,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ---------------------------------------------------------------------------- -- Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1 ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
