Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sparrow37
Posting Yak Master
148 Posts |
 Posted - 2010-04-02 : 15:15:20
|
| Hi All:I have a table name tableone which has two columns colum1 and colum2. Colum1 has value UserKeywords and colum2 has value like12|33|443|565|323|City|Council|Reg.Source|AbsenteeValidDate|PollingPlace|PollingPlaceAddress||OfficePhone|FaxPhone|Email2|WebPage|Notes||eMail_Test_Group||||StPattysDay|Absentee Y/N|Called Voters|Heritage Hills|Park District|Tax Map||||Prime Talley|OddYrGeneralPrimes|Prime Republican|2|3|0|2|4|2|2|0|5|5|5|5|6|0|6|0|0|0|6|4|6|0|0|2|0|0|0|7|7|6|I want to update this row to make the value of colum2 look like thisuser01|user02|user03| ................................... |user30| There are 30 values seperated by | sign . how can I do this using sql.Regards,asif hameed |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-02 : 15:24:41
|
| where do you get the user01|user02|user03| ................................... |user30| from? or do you want to hardcode this value??------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
update query