Blank or NULL? Is there a NVL function in SQL7 like in Oracle? If so you could do Select NVL(title,'')... Which would just give you an empty string when the title is NULL...
> Is there a way to concatenate two fields in access when one of them are > blank? > > Select Title + ' '+ subtitle as fulltitle > from table > > Fulltitle is blank when ether field is blank. > > Does any one know if this works in SQL server 7. > > 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
