Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> doing data conversions
Hello all. I am looking for a little point in the right direction with data conversions.
I have a column that has state abbreviations (GA). I need to convert them to the full name. Can regular SQL do this? Not sure if I somehow have to loop through the rows and use if/then/else logic.
Tks
jz Received on Thu May 10 2001 - 07:39:32 CDT