need help with SQL code
 

I am working out of a oracle data base and the interface uses SQL. I can not get my if then statements to work, all i am trying to do is this. The column produces a number and i want the number to be replaced with txt. For example if column x = 31 then break else column x = 40 the coaching etc.

Any cookie cutter code i can play with would be awesome, thanks for looking.

I'll post it tomorrow
Posted from my iPhone/Mobile device

Thanks, im sure i am missing something stupid simple to many hours infront of code.
Posted from my iPhone/Mobile device

to convert numbers to char use the to_char function

selection to_char(x,'9999') from tables where

or y = to_char(x,'9999')

the second operator is the mask you want the conversion to use when converting


Pl_SQL obscurity again.

I have the conversions with no problem but will this do the same as a if,then statement as the column produces 7 different 2 digit numbers.
Posted from my iPhone/Mobile device

Sounds like an impedance problem. Convert your JAVA_XL function to bit-hex_char. Input the print spooler bypassing the SQL evaporator.

If that fails, go to Tosche station and just get a new power converter.

-spence

every value will be converted yes,

to_char(x,'99')

its how the variables are processed regardless of the variable value as long as it doe not exceed two characters.

if you bypass the SQL evaporator you also bypass the Heisenberg compensator

if you bypass the SQL evaporator you also bypass the Heisenberg compensator