ORDER BY IIF

[Guest]

Can you use an IIF statement in an ORDER BY statement in SQL?

Trying to change the order depending on the if statement?

 

[Duane Hookom]

It would take less time to try it this than to post the question in a news
group.

Open Northwind and create a query with this SQL
SELECT Employees.*
FROM Employees
ORDER BY IIf([LastName] Like "D*",[LastName],"A");

 

[Guest]

Thanks for this, worked fine but didn't resolve my problem. I have a sort
order of [No of Rides] desc, [Last Name] Desc, however when the [No of Rides]
= 0 I want the sort order to swap to [No of Rides] desc, [Last Name] Asc.

Can it be done?

It would take less time to try it this than to post the question in a news
group.

Open Northwind and create a query with this SQL
SELECT Employees.*
FROM Employees
ORDER BY IIf([LastName] Like "D*",[LastName],"A");

--
Duane Hookom
MS Access MVP

Can you use an IIF statement in an ORDER BY statement in SQL?

Trying to change the order depending on the if statement?

 

[Duane Hookom]

Please respond with some sample records and the desired output.

--
Duane Hookom
MS Access MVP

Thanks for this, worked fine but didn't resolve my problem. I have a sort
order of [No of Rides] desc, [Last Name] Desc, however when the [No of
Rides]
= 0 I want the sort order to swap to [No of Rides] desc, [Last Name] Asc.

Can it be done?

It would take less time to try it this than to post the question in a
news
group.

Open Northwind and create a query with this SQL
SELECT Employees.*
FROM Employees
ORDER BY IIf([LastName] Like "D*",[LastName],"A");

--
Duane Hookom
MS Access MVP

Can you use an IIF statement in an ORDER BY statement in SQL?

Trying to change the order depending on the if statement?

 

[Guest]

Sorted it now. converted the [Last Name] to Asc and i.e. 100-(Asc([Last
Name]) +100 if points = 0 and if not then (Asc([Last Name]) then sort
Ascending.

it works fine

Please respond with some sample records and the desired output.

--
Duane Hookom
MS Access MVP

Thanks for this, worked fine but didn't resolve my problem. I have a sort
order of [No of Rides] desc, [Last Name] Desc, however when the [No of
Rides]
= 0 I want the sort order to swap to [No of Rides] desc, [Last Name] Asc.

Can it be done?

It would take less time to try it this than to post the question in a
news
group.

Open Northwind and create a query with this SQL
SELECT Employees.*
FROM Employees
ORDER BY IIf([LastName] Like "D*",[LastName],"A");

--
Duane Hookom
MS Access MVP

Can you use an IIF statement in an ORDER BY statement in SQL?

Trying to change the order depending on the if statement?