Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nogimmies

    Newbie: Adding Text to a column

    PHV - Thanks for the quick reply. I don't want to change the column from varchar to integer, but only want to update all the rows to reflect the results shown in the example I gave.
  2. nogimmies

    Newbie: Adding Text to a column

    I have a column named CardNumber in a table named Cards (fromatted 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...

Part and Inventory Search

Back
Top