|
|
Posted by PB on 08/22/06 08:19
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 '<'.
Navigation:
[Reply to this message]
|