That should be easy, don't you think?
set state = decode (state,'ID','Indiana','PA','Pennsylvania')
Cap Gemini Ernst & Young, sector Financial Services.
> If I use this syntax i get what I want displayed, how do you actually
> to update the column?
> select state, decode (state,'ID','Indiana','PA','Pennsylvania') from user
> >It's gonna be a large piece of code, but you can do it with Decode!
> >select decode( 'AL', 'alabama'
> > , 'CA', 'California'
> > , ...... -- and so on
> > , 'Unknown' -- value if none of the above match
> > )
> >from table
> >Also, you could write a function that looks up the code and returns the
> >description in a table.
> >This function has to be placed in a package then, and given a PRAGMA
> >RESTRICT REFERENCES( function_name, WNDS, WNPS )
> >select package.function( 'abbreviation' )
> >from table;
> >Good luck!
> >Patrick Sinke
> >Cap Gemini Ernst & Young, sector Financial Services.
> >> Hello all. I am looking for a little point in the right direction with
> >> conversions.
> >> I have a column that has state abbreviations (GA). I need to convert
> >> the full name. Can regular SQL do this? Not sure if I somehow have to
> >> through the rows and use if/then/else logic.
> >> Tks
> >> jz