Ok, I have to concatenate two fields together Author and SecondAuthor.
SecondAuthor some times has blank values in it.
What I have so far is (thanks Hatton)
SELECT LTrim(Rtrim(IsNull(Author, ' ') + '; ' + IsNull(secondAuthor, ' ')))
AS
Authors
FROM table
Now the only question is if a book only
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
loper
-Network / Web 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
3 matches
Mail list logo