Thanks that works!!! I thought about tiring that yesterday but, never did thinking that putting the ';' in the isnull would make it always not null and end up with a ';" always. I see that I was wrong.
Thanks much! Mark W. Breneman -Macromedia Certified ColdFusion 5 Developer -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 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 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 has one author how do I not have the ";" after the Author. Yes, I know I should break the Authors off into a related table but, that is not in the scope of the project. Thanks Mark W. Breneman -Macromedia Certified ColdFusion 5 Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists