>Zakaria,
>
>What you need to do first is to reduce the length of the sentence:
> remove characters and strings like ";" , " as ", chr(13), etc. Make it as a plain string.
>
>Something like this:
>
>lc1=STRTRAN(cVelden,CHR(13)+CHR(10),"")
>lc1=STRTRAN(lc1," as "," ")
>lc1=chrtran(lc1,";","")
>lc1=chrtran(lc1,CHR(9)," ")
>DO WHILE SPACE(2)$lc1
> lc1=STRTRAN(lc1,SPACE(2)," ")
>enddo
>
>*The length of your statement will be greatly reduced, and you will be able to apply:
>
>SELECT &lc1. from your_table
>
Still 7118 bytes :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.