If Statement?

[eggy168]

Hi, I have a query in Access and I am trying to put it into the View in SQL 2005, is it workable?

Access,
SELECT Field1, Field2, IIF(Field3>Field4,Field3, Field4) As Field5
FROM TableName1
Group BY Field1, Field2, IIF(Field3>Field4), Field3, Field4)

In SQL, it keeps having an error.

SELECT Feild1, Field2, Case When (Field3 > Field4), Field3 Then Field4 As Field5
FROM TableName1
Group BY Field1,Field2

Then I tried this, same error

SELECT Field1, Field2, IF(Field3 > Field4), Field3, Field4 As Field5
FROM TableName1
Group By Field1, Field2

Can anyone help?
Thanks so much.

 

[ethorn10]

SELECT Field1, Field2, CASE WHEN (Field3 > Field4) THEN Field3 ELSE Field4 END As Field5
FROM TableName1
Group BY Field1,Field2

 

[bborissov]

SELECT Feild1, Field2, 
       CASE WHEN (Field3 > Field4)
            THEN Field3
            ELSE Field4 END As Field5
FROM TableName1
Group BY Field1,Field2

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[eggy168]

Thank You Very Much!! It works Perfect!!!!