# Math Greater/Max function ?? - Microsoft SQL / MS SQL Server

Can someone help me please, I am using SQL 2000. Is there a function that can give me the bigest of two values. Example MyTable (2 Rows) Date1 Date2 ======================= ->2002-01-01 2003-01-01 ->2003-12-31 2002-12-31 Select Greater(Date1, Date2) as GreaterDate from MyTable Result (2 Rows) GreaterDate ========= 2003-01-01 2003-12-31 Thank you Christian Dubois Logilys Inc....

1. ## Math Greater/Max function ??

I am using SQL 2000.

Is there a function that can give me the bigest of two values.

Example

MyTable (2 Rows)
Date1 Date2
=======================
->2002-01-01 2003-01-01
->2003-12-31 2002-12-31

Select Greater(Date1, Date2) as GreaterDate from MyTable

Result (2 Rows)

GreaterDate
=========
2003-01-01
2003-12-31

Thank you
Christian Dubois
Logilys Inc.

Christian Guest

2. ## Re: Math Greater/Max function ??

Hi Christian,

There is no such function in T-SQL, but you can easily simulate it with
CASE:

SELECT CASE WHEN Date1 > Date2 THEN Date1 ELSE Date2 END AS GreaterDate
FROM Mytable

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Eurostop Ltd.

"Christian Dubois" <com> wrote in message
news:phx.gbl...

Jacco Guest

3. ## Re: Math Greater/Max function ??

Use CASE and one of the following methods:

If you don't have NULLs in the data:
SELECT
CASE
WHEN date1 > date2
THEN date1
ELSE date2
END
FROM MyTable

If you want the highest non-NULL value:
SELECT
CASE
WHEN date1 > date2
THEN date1
ELSE COALESCE(date2,date1)
END
FROM MyTable

If you want to return NULL where one of the dates is NULL
SELECT
CASE
WHEN date1 > date2 OR date1 IS NULL
THEN date1
ELSE date2
END
FROM MyTable

--
David Portas
------------
--

David Guest

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•