>>Thankyou for your answer. It worked fine with "CAST(0 AS Bit)". I tried CAST before, but I used the word "Logical" instead of "Bit", so it did not work for me.
>>Yes, saw the error when I had saved the message. It should be Ltrim or Rtrim instead of alltrim in the SQLselect abowe.
>>
>>But when I see your answer about the empty logical field, maybe it is better to use "CAST('' AS Text)" instead of "Ltrim(space(256))".
>>
>>Thanks again
>>/Kjell
>
>I hate to work with Text, NText or Image fields, but:
>
>CAST('' AS varchar(256)) -- or any bigger number
>
>will give you a memo and not traffic.
I have notifyed your comments about making an empty memofield. Thankyou.
And thanks all for your help with my problem.
I think I have all nessesary information now, for adding empty fields of different kind direct in my SQLselects.
Thankyou and have a good day or night (depending of your local time)
/Kjell