group by

hey all,
i was wondering...
if i have something like:
select fnam || ', ' || lnam
from mytable
how can i group this?
thanks,
rodcharHi,
In sql server concatination is + not pipe symbol (|)
select fnam + ', ' + lnam
from mytable
GROUP BY fnam , lnam
Thanks
Hari
SQL Server MVP
"rodchar" <rodchar@.discussions.microsoft.com> wrote in message
news:AE09394C-4241-4AC6-BCFE-3E81BD7716D4@.microsoft.com...
> hey all,
> i was wondering...
> if i have something like:
> select fnam || ', ' || lnam
> from mytable
> how can i group this?
> thanks,
> rodchar|||thank you.
"Hari Pra" wrote:

> Hi,
> In sql server concatination is + not pipe symbol (|)
> select fnam + ', ' + lnam
> from mytable
> GROUP BY fnam , lnam
> Thanks
> Hari
> SQL Server MVP
> "rodchar" <rodchar@.discussions.microsoft.com> wrote in message
> news:AE09394C-4241-4AC6-BCFE-3E81BD7716D4@.microsoft.com...
>
>