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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
