USING 'CASE' TO GROUP DATA

Giganews Newsgroups
Subject: USING 'CASE' TO GROUP DATA
Posted by:  PB (philbrierl…@hotmail.com)
Date: 22 Aug 2006

Hi,

Can anyone please help me with SQL syntax to create a second variable
based on the value of another (both numeric)?

My effort is below but I get a syntax error.

SELECT

charA,

CASE charA
WHEN < -199 THEN 2
WHEN < 31 THEN 3
WHEN < 82 THEN 4
WHEN < 100 THEN 5
WHEN < 105 THEN 6
WHEN < 111 THEN 7
WHEN < 143 THEN 8
WHEN < 165 THEN 9
WHEN < 233 THEN 10
WHEN >= 233 THEN 11
END AS Bin_charA

FROM X

Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '<'.

Replies