I think he doesn't want to alter the table... just the results. And it's not during the query, it's after you get the results... right? Otherwise you could query like select col1, col2, col3, '24' as myCol from mytable
-----Original Message----- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:12 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? do a google search on "alter table" -----Original Message----- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:13 AM To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1 Col2 Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1 Col2 Col3 myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
