I would like to add a where clause that if the 2 last chars in the field ID = '00' or '01' .
That way, i will get all the PO ID that finish with 00 or 01.
How can i do that?
thanks for your help.
SELECT DISTINCT ID, SCHED_NUM, SOURCE_ID, DEST_ID FROM LCLRPT.LCL_ORD_AUD WHERE SOURCE_ID IN ('21','24','03','60','67','34','57')