October 8th, 2012, 06:41 AM
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.
October 8th, 2012, 11:42 AM
Based on the sample that you have posted here, can you also post the expected result. That will give a clear picture of the requirement.
October 9th, 2012, 02:59 AM
Would like this
As long as they are greater then 5.