Thank you for your help,

I am usually using on vfoxpro a TEXTMERGE like the following:

TEXT TO L_SQLCMD TEXTMERGE NOSHOW PRETEXT 1
SELECT * from amaster
WHERE (BMASTER.YEAR = 2006)
ENDTEXT

is there any TEXTMERGE in sql 2005 the same function in vfp.