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 bkrike 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: *

  • Users: DWSRAMBO
  • Content: Threads
  • Order by date
  1. DWSRAMBO

    SQL - Convert a 9 byte Character column to an Integer

    I am trying to convert a 9 digit character column to an integer column. I'm not sure whether the field has spaces or non-numeric characters. I can Ltrim/Rtrim the spaces off either end before converting but if there are spaces or non-numeric characters within I need to make the resulting...
  2. DWSRAMBO

    Dropping leading zeros when adding 1 to a 3 pos char column

    Greetings, I have a question regarding what I think is probably a fairly basic question but through a couple hours of trying various things (including cast, convert, and a host of others) I have been unable to come up with an answer. For this example I have cut pertinent information out of the...

Part and Inventory Search

Back
Top