Results 1 to 5 of 5
  1. #1
    Join Date
    May 2002
    Location
    wakefield, ri
    Posts
    35

    Cool Unanswered: Syntax to Display Part of a Text Field

    I would like NOT to display part of a text field that has different text lenghts.

    For example two field contents are:

    abcdefg/1234567 and abcdefg/12345

    I don't want to display the abcdefg/ (first eight digits)
    the desired results are 1234567 and 12345.

    I'm stumped, any ideas?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    select mid(textfield,9,len(textfield)-8) as partof ...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2002
    Location
    wakefield, ri
    Posts
    35
    thank you R937!

    Now can I add text to the field? I tried: & "xxxxx" and it didn't take.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    can i see your entire query please
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    May 2002
    Location
    wakefield, ri
    Posts
    35
    figured it out r937 thanks again!

Posting Permissions

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