
October 8th, 2012, 05:41 AM
|
|
Registered User
|
|
Join Date: Jul 2008
Posts: 4
Time spent in forums: 54 m 7 sec
Reputation Power: 0
|
|
|
SQL 2005 query help if you could.
I have a table with around 800,000 enteries.
The problem is 1 of the fields has data saved like this
1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-19-20(most enteries are differant, did 1-20 as an example)
Wont let me insert image
I need to change 6 9 and12 to 5 (if it is currenlty greater then 5) but i have no idea how, and as i said before each enterie is differant.
If anyone could help it would be great.
Thanks
|