Conditional Select problem

rodmcleay · February 21st, 2005, 01:05 AM

Hi All,
I have tried several methods to try to get a field value one of two optiones based on its value.
This is what I think I should be doing, but I am not aware of the correct syntax/logic.

Code:

Select 
title,
price,

IF royalty = 10
Begin
select 'Y'
end
else
begin
Select 'N'
end

from titles

This sample is using pubs but basically I whish to make a query that will return 'Y' if the value of the field is 1 or 'N' if it is 2 or greater.

In the end I wish to order by this putting all the Y's at the end of the query

Any help would be greatly appreciated

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

rodmcleay · February 21st, 2005, 01:17 AM

Found Solution,
Ended up using CASE insead of If/Else.
If anyone knows the sysntax for If/Else in this situation I'm still interested.

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

robprell · September 7th, 2005, 07:37 PM

Is there a reason you can't just use a "case" statement for what you want to do? See SQL help for how.

robprell · September 7th, 2005, 07:42 PM

Is this what your looking for???
Select title,price
,test = case royalty when 10 then 'Y' else 'N' end
from titles
order by test

or is there a particular reason you want to use the word "if"?