Don't think you can. I found this reply to an identical question on
the Web:
"I've been looking through the ANSI SQL documentation, and I can't
find any syntax to do that. The "allow zero length" is an MS-Access
quirk, anyway -- most databases (e.g. SQL Servers) just allow it --
and it certainly seems odd that the default is to not allow it. Sorry,
but all I can think of is to use some DEFAULT value so that you don't
ever have an empty string. It's a bit of a "kludge", but a single
space will work."
Jamie
On Wed, 30 May 2001 12:31:26 -0400, in cf-talk you wrote:
>How do you to set allow zero length in access 2000 for memo field using sql
>statement when adding column using alter table ?
>Thanks
>Mike
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
