User Profile

Collapse

Profile Sidebar

Collapse
nogimmies
nogimmies
Last Activity: Dec 12 '06, 09:00 PM
Joined: Dec 6 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nogimmies
    replied to Adding text to a column!
    in SQL Server
    iburyak, that appears to have worked. Just to make sure that command didn't change the field type to integer did it? I wanted to leave it as varchar. Thanks to you and all the previous poster for the help.
    See more | Go to post

      Leave a comment:

    • nogimmies
      started a topic Adding text to a column!
      in SQL Server

      Adding text to a column!

      I have a column named CardNumber in a table named Cards (formatted as varchar) with numbers ranging from 1 to 65534. I am trying to change all the card numbers to start with 84 and fill with 0's until the card number and finish with 9 characters. So it would look like this.

      Old column
      6
      19
      234
      8521
      45956

      Updated...
      See more | Go to post
      Last edited by nogimmies; Dec 6 '06, 09:05 PM. Reason: Bad formatting
      No activity results to display
      Show More
      Working...