SELECT LTrim(Rtrim(IsNull(Author, ' ') + IsNull('; ' + secondAuthor, '
')))
AS
Authors
FROM table
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 15 januari 2002 22:25
To: CF-Talk
Subject: concatenate blank fields SQL and the pesky
Ok, I have to
Server Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:52 AM
To: CF-Talk
Subject: RE: concatenate blank fields SQL and the pesky
SELECT LTrim(Rtrim(IsNull
2 matches
Mail list logo