I have a complex select query and must now add an additonal condition. One of the elements must be numeric. The 'isnumeric' function keeps erroring out on me. select FWVCCOA_FMS_CENTER cfmsctr, fwvccoa_fund_code cfundcde, fwvccoa_orgn_code corgncde, ...
In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?