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 > >>
><a href=wc.dll?testProcess~HelloWorld~&bedid=16~&vacid=41
>
>