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 and the pesky Ok, I have to

RE: concatenate blank fields SQL and the pesky

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