I think a better choice would be: INSERT INTO Y(Value) SELECT ',' + Value + ',' as ValueComma FROM X WHERE blah blah blah.
Susan Kennedy Database Programming Tallahasse, FL -----Original Message----- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 4:46 PM To: SQL Subject: INSERT/SELECT FROM and modifying the data Hey gang - Got an issue I'm not quite sure how to tackle. I've got two tables, let's call them X and Y, with a field, let's call it Value. I'm importing data into Y from X using an INSERT/SELECT FROM, i.e. INSERT INTO Y(Value) SELECT Value FROM X WHERE blah blah blah. But what I want to do is modify the content of "Value" in the process - not do a 100% straight transfer. I want to add a comma at the start and end - so that "Joe" in X would get inserted into Y as ",Joe,". Would INSERT INTO Y(',' + Value + ',') do the trick? Thanks in advance, --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
