The statement turned out to be 273 characters (I should have been paying closer attention) and once I used text..endtext it worked :o)


>If you get an error than move ORDER clause after WHERE. The T-SQL is particular about the clauses order.
>
>>Any idea why everything works fine until I add the WHERE clause?
>>
>>

>>lcfilter = 'ABC123'
>>SQLEXEC(lnConnhandle," select t22.field3, t23.field3, t1.field1, t1.field4 from table1 t1 ;
>>   JOIN table2 t22 ON t22.field1 = 'FKEY1' and t22.field2 = t1.field2 ;
>>   JOIN table2 t23 ON t23.field1 = 'FKEY2' and t23.field2 = t1.field3 ;
>>   ORDER BY 3, 4 ;
>>   WHERE t1.field1 = ?lcfilter",'sqlresults')
>>