SQL CASE '>' Question 1

[FinalPrime]

For the following --test-- code I get
'incorrect syntax near >'

SELECT DataSales.SalePrice,
CASE DataSales.Saleprice
WHEN > 35000 THEN 'Sold'
ELSE 'NotSold'
END 'SaleGreater35000'
FROM DataSales
WHERE DataSales.SalePrice > 35000

Any help needed to produce > results.

thanks in advance,

finalprime

 

[gmmastros]

SELECT DataSales.SalePrice,
  CASE [!]When [/!]DataSales.Saleprice > 35000 THEN 'Sold'
  ELSE 'NotSold'
  END 'SaleGreater35000' 
FROM DataSales
WHERE DataSales.SalePrice > 35000

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[r937]

you're using simple CASE syntax, you want searched CASE syntax

SELECT SalePrice
     , CASE WHEN Saleprice > 35000 
            THEN 'Sold'
            ELSE 'NotSold'
        END AS SaleGreater35000
  FROM DataSales
 WHERE SalePrice > 35000

note, however, that you're shooting yourself in the foot with the WHERE clause



r937.com | rudy.ca