I use Oracle 8, With Platinum's Forest and Trees as a development tool.
I am attempting to replace a columns results with an alias identifier.
(example: if I get back the letter F in my column then I would like to
replace them all with the word FIRST and L with the word LAST and so on)
there will be many instances of L's and F's along with about 10 other
letter Identifiers.
In Forest and Trees I can use an IFVAL
function in the Select statement. But, if there are more than one
grouup of letters it creates a new column for each. Then I have to go
through a bunch of hastle to joint all data back into a single colums..
Any suggestions.. Maybe Oracle could return what I need through the SQL
statement.
Thanks
Received on Tue Oct 06 1998 - 14:41:15 CDT
