Very Computer

SELECT     COUNT(id) AS Number, seleccion & 4096 AS HasByte13
FROM         usuario2
GROUP BY seleccion & 4096

I will get a result like:
number HasByte13
1234    4096
9988         0

But i want something like:
number HasByte13
1234    yes
9988    no

So in access i would do:
SELECT     COUNT(id) AS Number, iif(seleccion & 4096=0;"No"; "Yes") AS
HasByte13
FROM         usuario2
GROUP BY seleccion & 4096

but this is an error in SQL server.....

any ideas?

Quote:> So in access i would do:
> SELECT     COUNT(id) AS Number, iif(seleccion & 4096=0;"No"; "Yes") AS
> HasByte13
> FROM         usuario2
> GROUP BY seleccion & 4096

SELECT
    HasByte13 = CASE WHEN seleccion & 4096=0 THEN 'No' ELSE 'Yes' END,
    ...othercolumns...
    FROM ...

A

regard,

Ned

Quote:>-----Original Message-----
>Hi, I have this simple query:

>SELECT     COUNT(id) AS Number, seleccion & 4096 AS
HasByte13
>FROM         usuario2
>GROUP BY seleccion & 4096

>I will get a result like:
>number HasByte13
>1234    4096
>9988         0

>But i want something like:
>number HasByte13
>1234    yes
>9988    no

>So in access i would do:
>SELECT     COUNT(id) AS Number, iif(seleccion &

Quote:>HasByte13
>FROM         usuario2
>GROUP BY seleccion & 4096

>but this is an error in SQL server.....

>any ideas?

>.