Replace two Column records for specified number of rows. for example...
| Custname | CustEmail |
| Muthu | |
| Ramesh | |
| Sridhar | |
| Kumar |
For above table “Custname” column Records move to “CustEmail” column records place and“CustEmail” column records move to “Custname” column Records place.
for Specified number of rows (it means effects the number of rows in table )
thank you .. .
Dipankar BiswasPosted May 14, 2015, 1:24 AM
SELECT REPLACE(yourcolumn,'ValueInTheColumnTobeReplaced', 'NewValue') as replacedColumnName FROM yourtable
see more..http://forums.asp.net/t/1622369.aspx?replace+a+column+value+with+select+statement