Counting GUID s

Is there a way to do a count on a guid in sql 2000, if I try I get an
error when running the query.
thanks for your helppltaylor,
I know, this is a bogus restriction. Cast the column as a varchar(36).
select count(cast(MyGUID as varchar(36)))
from ...
-- Bill
<pltaylor3@.gmail.com> wrote in message
news:1173896580.729093.117070@.d57g2000hsg.googlegroups.com...
> Is there a way to do a count on a guid in sql 2000, if I try I get an
> error when running the query.
> thanks for your help
>|||pltaylor,
I know, this is a bogus restriction. Cast the column as a varchar(36).
select count(cast(MyGUID as varchar(36)))
from ...
-- Bill
<pltaylor3@.gmail.com> wrote in message
news:1173896580.729093.117070@.d57g2000hsg.googlegroups.com...
> Is there a way to do a count on a guid in sql 2000, if I try I get an
> error when running the query.
> thanks for your help
>