We help IT Professionals succeed at work.

GREATER function in MS SQL

BlueAlien
BlueAlien asked
on
Medium Priority
2,089 Views
Last Modified: 2008-02-26
Hi.

Is there a function in MS SQL that returns the greater value of 2 expressions, like GREATER(exp1,exp2) in Sybase?

Thanks.
Comment
Watch Question

TimCotteeHead of Software Services

Commented:
Hi BlueAlien,

No but you can use the case construct:

Select Case When ValueA>ValueB Then ValueA Else ValueB End As GreatestValue

Tim Cottee
You can also create a User Defined Function (UDF) in SQL Server which will carry out the same operation, and you could even name that UDF GREATER.

AW

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.