Posted by Ed Murphy on 08/22/06 08:53

On 22 Aug 2006 01:19:18 -0700, "PB" <philbrierley@hotmail.com> wrote:

>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 '<'.

case
when CharA < -199 then 2
when CharA < 31 then 3
<etc.>

[Back to original message]