Reverse full name

Hello all,
I have a SQL db that stores first & last names in one field (i.e. John Doe).
Does anybody know how to get reporting services to show the name as
lastname, firstname?
Thanks.you could create a temp table in the SQL, then use a function to get the
first part of the string, everything up to the space for example.
Then use another function to get the last part of the string to get the last
name. You can then combine them into a single field with the last name first.
"Jeff Bentivoglio" wrote:
> Hello all,
> I have a SQL db that stores first & last names in one field (i.e. John Doe).
> Does anybody know how to get reporting services to show the name as
> lastname, firstname?
> Thanks.
>
>