Garry Saddington wrote:
> It does work but returns a column called case. How can I return the case > column as 'postcode'?
selectCASE WHEN postcode ilike '%OO%' THEN ''END as postcodefrom addresses
-- Guy Rouillier