> TEXT TO ocursorAdapter.SELECTCMD NOSHOW TEXTMERGE PRETEXT 15 >SELECT HDBK, Hid , HDOCNO, HAMOUNT, STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY, >STR(Createdon) AS 'createdon' , hremint FROM <<.TABLES>> >WHERE ALLTRIM( HDBK ) LIKE '<<Vp_in>>' > ENDTEXT >What database you're using? There is no alltrim function in SQL Server.