>Use PADR to insure the result field length. Otherwise FoxPro will determine the size of the field based on the first physical record in the table.

>PADR([<a href=wc.dll?testProcess~HelloWorld~&bedid=]+
>transform(bedid)+[~&vacid=]+transform(vacid)+[>],254) as pagelink;	
>

Ah, it works that way. Thanks for your help

>
>
>>I have the following sql syntax:
>>

>>SELECT *, ;
>>[<a href=wc.dll?testProcess~HelloWorld~&bedid=]+
>transform(bedid)+[~&vacid=]+transform(vacid)+[>]as pagelink;	
>>FROM vacancies;
>>WHERE vacancies.bedid = nBedid;
>>INTO CURSOR tVacancies
>>
>>

>>
>>For nBedid = 16 the vacid equals 41. I get the follwing string result:
>>

>><a href=wc.dll?testProcess~HelloWorld~&bedid=16~&vacid=41
>>

>>
>>What happened with [>]? What am I doing wrong?