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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gfranklin

  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

    Sreenivas That worked great! I have just one more question. Now how can I delete the - from the end of the serial number? Thanks, Gabby
  3. 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...
  4. gfranklin

    How to do a Column Split in SQL

    Thomas, This is the message I get when I run it! Server: Msg 174, Level 15, State 1, Line 2 The substring function requires 3 arguments. update CallLog set test= substring(cause,charindex(cause,'-')+1) , cause = substring(cause,1,charindex(cause,'-')-1) ; Where did I go wrong? Thanks, Gabby
  5. gfranklin

    How to do a Column Split in SQL

    Thomas, Remember I'm new to SQL so when you say to "populate the new column and adjust the original/old column" I'm not really sure where I'm suppose to go or what to do. Can you give me detailed instructions Please? Thanks, Gabby
  6. gfranklin

    How to do a Column Split in SQL

    SQLBill, Here is an example of what the data in that column looks like! rn-123567 I would like to split it into 2 separate columns and drop the - if possible. Thanks for you help! Gabby
  7. 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
See more

Part and Inventory Search

Back
Top