Try Space(256).
HTH,
Richard
>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.
>
>Thanks
>Gaylen
State of Florida, DCF