numeric test in SQL
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,        ftvfund_orgn_code_def forgncde,        fwvccoa_prog_code  cprogcde,        ftvfund_prog_code_def fprogcde   from temple_finance.fwvccoa, ftvfund [strong]where ISNUMERIC(FWVCCOA_ACCI_CODE)= 1[/strong]  and fwvccoa_fund_code [...]

Answer Question   |  December 15, 2009  2:35 PM
SQL error messages, SQL Testing, WINSQL Numeric Function

Function to find greatest numeric value across different fields
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?

Answer Question   |  August 25, 2009  2:52 AM
Oracle SQL, WinSQL, WINSQL Numeric Function