I need to fetch the value from a column which is of type TEXT, and then I need to concatenate the values of all the rows for that same column and store it into a new table. I mean, if I have a column with the name Address of type TEXT. Then I need to merge all the available address.
Can some one help me with this?
Last edited by Arun; 07-21-2011 at 02:14 PM.