Bit and Text Columns

[Aaron Bertrand - MVP]

For bit, you can convert to TINYINT in both SELECT and GROUP BY clauses.

Don't understand why you would group by TEXT... you might be better off
doing a subquery / derived table.




"Merwin12" <pablomb@umdnj.edu> wrote in message
news:0bd501c344bd$e90013f0$a001280a@phx.gbl...

> I have a sql statement that fails when grouping the
> bit and text columns.
>
> Is there a way to get around this???
>
> Thanks.

[Gert-Jan Strik]

As for grouping on TEXT columns, the only work around I can think of is
to group on SUBSTRING(<textcolumn>,900). Of course, with this work
around you will lose a lot of precision.

Gert-Jan


Merwin12 wrote:

>
> I have a sql statement that fails when grouping the
> bit and text columns.
>
> Is there a way to get around this???
>
> Thanks.