DISTINCT WITH SUBSTR ????
Ok my query works, but I need to pull in the distinct 5DIGIT ZIP CODE, am on 10g.
Putting it in front of the SUBSTR function, doesn't seem to work.
SELECT FLS_STORE_OF_PROMOTION_NUM, DISTINCT SUBSTR(ADDR_POSTAL_CODE, 1, 5) as ZIP5
FROM TABLE;
How do I do that ?