How to initialize a string to Null

Hi All:
I have a file (table in MS-SQL) with a string field which should be NULL when it's created. I'm using:

sField = Null

but it doesn't work (the field is created empty, but not Null).
If I use a hidden edit control with the "Return NULL if empty" option set, everything works fine.

Shouldn't both cases work in the same way?

Thanks;
Michael

Hello Michael,

Did you set the concerning settings in your analysis.
Filedescription: NULL supported
Itemdescription: Default to NULL

HTH.

Michael,

I found the same problem but resolved it by using

sField..Null=true

which worked fine.

Milton