Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    36

    Unanswered: OK, Another Problem

    Thanks for all the assistance with the time issue I was having. It looks like I can make the last code work somehow. I'll have to figure out how to incorporate it in, but I think I can probably manage that.

    Here's my next question! I have a field in my source table that contains a range of values, separated by a dash. I need to parse this out into two separate destination table fields. The lengths before and after the dash will vary, so I need to be able to read up to the character, then from the other side of the character. Any suggestions on parsing? Books on line has not provided me with the answer (yet).

    For example:

    0.1-3.7 needs to be 0.1 (Field1) and 3.7 (Field2)
    12.5-27
    100-199

    Thanks! This board has been extremely helpful for me (the pseudo-DBA).
    Dirk

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    checkout CHARINDEX and PATINDEX either one of these should work for you.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Jun 2002
    Posts
    36
    PATINDEX works perfectly for what I need.

    Thanks again!
    Dirk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •