I have the following query i want to run
select cat_id, name, description, price, new from table_name
WHERE price > 0
Now the column "new" contains a bolean record which is either "Y" or "N" what i want to happen is that when the column returns results instead of outputting the "Y" I want the records to show the number "1" & "N" substituted by the number "0"
thanks in advance