Hi
SELECT T0.docnum, T2.name, T1.u_abc, T0.docdate, T1.quantity FROM OIGN T0 INNER JOIN IGN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN [@temp] T2 ON T1.U_abc = T2.Code
where t0.docdate >= [%0] and t0.docdate <= [%1] and t2.name = [%3] ]
I want that in variable 3 it should list only those whose name starts with 'A' during selection
Thanks