"Ryan Mcbee" <RyanMcbee@discussions.microsoft.com> wrote in message
news:2A995187-4FD1-4956-9CF1-6160765C4A4D@microsoft.com...
>I am writing a query in which I want to select a field and not have the
> trailing blank spaces. Here is my query: select employid, lastname + ','
> +
> frstname as name from upr00100
>
> The results look like this "West ,Paul" or "Mcbee
> ,Ryan"
>
> How can I get results to look like "West,Paul" or "McBee,Ryan"?
>
> Thanks,
> Ryan

"Hugo Kornelis" <hugo@perFact.REMOVETHIS.info.INVALID> wrote in message
news:t7b7h3t6bvmmt49f6qr503c9h70744foa3@4ax.com...
> On Mon, 15 Oct 2007 07:29:05 -0700, Ryan Mcbee wrote:
>
>>I am writing a query in which I want to select a field and not have the
>>trailing blank spaces. Here is my query: select employid, lastname + ','
>>+
>>frstname as name from upr00100
>>
>>The results look like this "West ,Paul" or "Mcbee
>> ,Ryan"
>>
>>How can I get results to look like "West,Paul" or "McBee,Ryan"?
>
> Hi Ryan,
>
> SELECT employeeid, RTRIM(lastname) + ',' + firstname AS name
> FROM upr00100;
>
> --
> Hugo Kornelis, SQL Server MVP
> My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

On Mon, 15 Oct 2007 07:29:05 -0700, Ryan Mcbee wrote:

>I am writing a query in which I want to select a field and not have the
>trailing blank spaces. Here is my query: select employid, lastname + ',' +
>frstname as name from upr00100
>
>The results look like this "West ,Paul" or "Mcbee
> ,Ryan"
>
>How can I get results to look like "West,Paul" or "McBee,Ryan"?