#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2008
    Posts
    4
    Rep 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
  2. #2
  3. Humble Learner
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Location
    Bangalore, India
    Posts
    280
    Rep Power
    120
    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.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2008
    Posts
    4
    Rep Power
    0
    Would like this
    1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-19-20

    to become

    1-2-3-4-5-5-7-8-5-10-11-5-13-14-15-16-17-18-19-20

    As long as they are greater then 5.

    thanks

IMN logo majestic logo threadwatch logo seochat tools logo