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 wOOdy-Soft 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: gfranklin
  • Content: Threads
  • Order by date
  1. gfranklin

    Update Query

    I need to run an update query to remove the dash - from the end of my column data but I'm unsure of the syntax example of the data: 980890121- 239451- 4865000- The lengths of the data in that column are not the same size which makes it difficult for...
  2. gfranklin

    Update Query

    I'm in desperate need of some help with an SQL Update query... I have a column that contains serial numbers and a fail code divided by a dash. I would like to split the columns into two separate columns but, the problem is they aren't the same length. example: 980890121-1, 239451-1...
  3. gfranklin

    How to do a Column Split in SQL

    I have a column in my sql table that contains 2 different values, I would like to separate them into 2 different columns! How do I go about doing this? I'm a beginner to sql so my knowledge is very limited! Thanks in advance for your help! Gabby

Part and Inventory Search

Back
Top