Thanks Sergey - I owe you two stars as I clicked on the wrong icon.

Gaylen

>>I need to create a blank memo field in a sql statement. I know you can use {} for blank date and 00000.00 for numeric and space(x) for character fields. Anyon know what is it for memo fields?
>>
>>Never had to use it till today.
>>
>Ho Gaylen,
>
>See Re: Adding memo field as calculated field Message #683252