User Profile

Collapse

Profile Sidebar

Collapse
loydbrahn
loydbrahn
Last Activity: Sep 19 '06, 04:12 PM
Joined: Sep 18 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • loydbrahn
    replied to Update using Substring
    in SQL Server
    Thanks for the help!
    See more | Go to post

      Leave a comment:

    • loydbrahn
      started a topic Update using Substring
      in SQL Server

      Update using Substring

      I have a SQL Table I am trying to update...I would like to add '-000' to the end of every value in a column, GLSegment.

      I can do this for one row using this statement...

      UPDATE CmpnyGLSegments
      SET GLSegment = (SELECT SUBSTRING (GLSegment, 1, 3) FROM CmpnyGLSegments WHERE RowID = 2)+'-000'
      WHERE RowID = 2

      but do not know how to do this for every row at once. I would like to take each existing...
      See more | Go to post
      No activity results to display
      Show More
      Working...