>Hi Fred,
>
>>I know that you know that, but I think it needs to be clarified:
>>
>>String length = 2GB
>>Statement length = 8K
>
>Somehow I must be little bit dense today, sorry. *s* Yes, I should have clarified this, just like I should have clarified that a single string constant can't exceed 254 charecters (as Ken pointed out correctly), which is probably the problem with the select statement here.
>
>Christof

254 length also applies to a table field value. :)