decode expression question

[redhonda9834]

Hello Everyone,

I have a decode expression i need help with.



decode(location_area, alternate_area, location_area, alternate_area) "Current_Location",

Am I correct with this if statement?

if location_area = alternate_area then
current_location = location_area
else
current_location = alternate_area

[Perceptus]

Is Decode a User Defined Function?

[redhonda9834]

I don't think its a user defined function. I think it is part of MSACCESS.

[orange]

Decode is an Oracle function


I think Access's Choose may be the closest in Access functions

[redhonda9834]

Crap... sorry, i forgot to mention this is a sql pass through query that is querying an oracle table.

Does the if logic make sense?

[orange]

Can you show us the SQL of the pass through query?