"Allow Zero Length" and CREATE TABLE

[Anon]

Is there any way to set the "Allow Zero Length" attribute in an SQL statement? So far I've only found 1 page on the Internet (searching Google and AV) and the guy said 'no, you can't do it'.

[Anon]

I'm not sure if I've understood here, but don't you just use NULL? ie accept nothing in the box?

[Anon]

Nulls and Zero Length Strings are different things James. I guess the best way to explain it is that a Zero Length String is a String with nothing in it whereas a NULL value is no string at all.

The following is from Microsoft:
"There is no provision in the CREATE TABLE syntax to explicitly set the AllowZeroLength property"

[Anon]

Ridiculous isn't it?

How is one supposed to be able to create tables on the fly without being able to set such an important property???