[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-developers] Contact function for SQL (howto in mssql)
|
From: |
Edgar Luna |
|
Subject: |
Re: [Phpgroupware-developers] Contact function for SQL (howto in mssql) |
|
Date: |
Fri, 12 Sep 2003 20:54:19 -0500 |
|
User-agent: |
Gnus/5.1003 (Gnus v5.10.3) Emacs/21.3 (gnu/linux) |
"Chris Weiss" <address@hidden> writes:
> SELECT RTRIM(ISNULL(last_name,'')) + RTRIM(ISNULL(org_name,'')) + ... as name
> ...
> The RTRIM is needed to remove any whitespace otherwise you get something like
> "name
> orgname
> "
Ok, I'll code that then.
Thanks a lot.
--
Edgar Antonio Luna Díaz - http://www.sogrp.com
Fingerprint: C008 5EAC 5272 AC8C 7589 4821 8B34 6166 8733 8310