1
  • 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,       ...

    Sherryborden85 pointsBadges:
  • How to block AS/400 users from using WinSQL

    How can I block AS/400 users to modify data using WinSQL from the PC? Already I have some users that have insalled into their PCs iSeries Access and WinSQL, they run WinSQL that uses an ODBC to change data using SQL sentences. *** WinSQL is universal database management tool that can be used with...

    Maguito5 pointsBadges:
  • 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?

    Kevling5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following