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;	

>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?