I should have qualified that, it works with a view Won't work: select firstname + ' ' + Lastname as name from peopletable where name = 'Bruce Willis'
But build the firstname + ' ' + Lastname as name into your view and the following will work (provided name there). select * from testview where name = 'Bruce Willis' At 03:21 PM 2/26/2003 -0500, you wrote: >You wouldn't know off hand if it works in MSSQL Server? > >Regards, > >Dave Bosky >Sr. Multimedia Web Designer >Horry Telephone Cooperative, Inc. >office: (843)369-8613 >[EMAIL PROTECTED] > > >-----Original Message----- >From: Selene Bainum [mailto:[EMAIL PROTECTED] >Sent: Wednesday, February 26, 2003 3:10 PM >To: SQL >Subject: RE: Combining fields > > >You can use: > >SELECT Fname + ' ' + Lname AS FullName > >Using single quotes instead of double quotes. You may be able to use: > >Where FullName = 'Dave Bosky' > >But some db's won't like that because FullName isn't a real field, so >you may need to do: > >WHERE Fname = 'Dave' AND Lname = 'Bosky' > >Selene Bainum >[EMAIL PROTECTED] >Team Macromedia >WebTricks >http://www.webtricks.com > > > > >-----Original Message----- >From: Bosky, Dave [mailto:[EMAIL PROTECTED] >Sent: Wednesday, February 26, 2003 2:56 PM >To: SQL >Subject: Combining fields > > >If I have a table called MYNAMES with ID, FName, LName fields how can I >use both FNAME and LNAME to match a single variable? > >Something like >select Fname+" "+Lname as FullName >from MyNames >Where FullName = 'Dave Bosky' > > >Regards, > >Dave Bosky >Sr. Multimedia Web Designer >Horry Telephone Cooperative, Inc. >office: (843)369-8613 >[EMAIL PROTECTED] > > > >HTC Disclaimer: The information contained in this message may be >privileged and confidential and protected from disclosure. If the reader >of this message is not the intended recipient, or an employee or agent >responsible for delivering this message to the intended recipient, you >are hereby notified that any dissemination, distribution or copying of >this communication is strictly prohibited. If you have received this >communication in error, please notify us immediately by replying to the >message and deleting it from your computer. Thank you. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
