Hello all,
I am writing a query that is pulling in data from a column labeled "Priority". What I need help with is one of the common values returned from this column is "Normal". What I need it to say is "Routine" where ever it comes in as "Normal" in my query results. I was looking at the 'Format' function but it seems to be only for dates. I cannot use an Update query because I don't have the rights to update this table.
I also use SQL developer and know about the to_char function but that also seems like it's only for converting date formats.
Does anyone know of a function that I could use to do this? If this is confusing I'll try to explain it a different way.
Thank you,
rjohnson