TEXT TO lcSelect NOSHOW PRETEXT 15 TEXTMERGE SELECT b.* FROM Table1 a INNER JOIN Table2 b on LTRIM(RTRIM(a.unitcode)) = LTRIM(RTRIM(b.unitcode)) AND LTRIM(RTRIM(a.unittype)) = LTRIM(RTRIM(b.usertyped))" ; WHERE a.inactive = 'TRUE' AND a.untypeid = <<sqlresults.untypeid>> -- If untypeid type is differenet than numeric you must convert it ENDTEXT * or TEXT TO lcSelect NOSHOW PRETEXT 15 TEXTMERGE SELECT b.* FROM Table1 a INNER JOIN table2 b on LTRIM(RTRIM(a.unitcode)) = LTRIM(RTRIM(b.unitcode)) AND LTRIM(RTRIM(a.unittype)) = LTRIM(RTRIM(b.usertyped))" ; WHERE a.inactive = 'TRUE' AND a.untypeid = ?sqlresults.untypeid -- No convertion needeed ENDTEXT