Great, I wasn't in a place where I could easily test it out so I just need to make sure my syntax was correct!
Thanks!! Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Jim Vosika" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, July 05, 2002 10:57 AM Subject: RE: Adding Values (SQL) > It should work exactly how you have it...It does for me. > > Jim Vosika > http://www.tinyclick.com > FREE URL Shortening! > > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 05, 2002 10:37 AM > To: CF-Talk > Subject: Adding Values (SQL) > > I don't have any cheet sheets with me, but I need to do a simple query > and have an addition statement in the SELECT statment of a query. > > Something like: > > SELECT, column1, column2 + 3 AS NewQty > FROM..... > > Basically column2 is a numeric value and I want to add a number to it > and rename the Column to NewQty. > > Does anyone have the correct sytax? > > Thanks! > > Paul Giesenhagen > QuillDesign > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
