Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Question Unanswered: Query partial text from field

    Hello Everyone,

    I have been trying to find a way to select a portion of text to the left of a certain place in a field, but have had no luck. Any help would be greatly appreciated. I hope the example below can better illastrate my goal.

    Example:
    Current Output:
    XXX-342-sds-2

    Desired output:
    XXX-342

  2. #2
    Join Date
    Mar 2002
    Location
    Sacramento, CA
    Posts
    120

    Sorry for the obvious

    Look up the Left function in Help files.
    It'll do exactly what you're asking.

    Michael

  3. #3
    Join Date
    Oct 2002
    Posts
    2
    Thanks alot

Posting Permissions

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