concatenate blank fields SQL and the pesky

2002-01-15 Thread Mark W. Breneman
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

RE: concatenate blank fields SQL and the pesky

2002-01-16 Thread Pascal Peters
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

RE: concatenate blank fields SQL and the pesky

2002-01-16 Thread Mark W. Breneman
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