>>However, if you want to run your statement against different back-end, you would not always be able to convert to desired field type if the backend doesn't support it. In this case you can have a cursor with needed structure and append from the resulting cursor.
>
>Yes I saw the error when the message was saved. It should be Ltrim or Rtrim instead of Alltrim.
>
>Yes, CAST works on local tables, but not with SQLselect to SQLserver 2005.
>So my exampe is the only way I know, to make an empty memofield.
>
>Thakyou for your answer
>/Kjell

See Borislav's answer for a solution using CAST(0 as bit)