You'll just have to play around with the syntax http://support.microsoft.com/default.aspx?scid=kb;en-us;180841
you could try the NULL keyword.... This page says you can use "NOT NULL" so you can probably use "NULL" too.. which is probably the default. Unfortunately, I can't find any references to zero-length fields... Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233940 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54