No problem! Cheers.
At 04:41 PM 2/26/2003 -0500, you wrote: >That worked like a dream! Thanks. > >Regards, > >Dave Bosky > > > >-----Original Message----- >From: Mary Jackson [mailto:[EMAIL PROTECTED] >Sent: Wednesday, February 26, 2003 3:46 PM >To: SQL >Subject: RE: Combining fields > > >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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
