Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: Access to SQL conversion

    I'm trying to convert an Access Query to SQL. I am using a "Mid Statement" to select a portion of a value:

    Mid([ITEM_NUMBER],2,7)

    When I try to parse this statement in SQL I always get an error "Does not recognize Mid as a valid procedure."

    Is there an SQL statement I could use to accomplish this?
    Thanks,
    Bill

  2. #2
    Join Date
    Oct 2003
    Location
    Newcastle, Australia
    Posts
    51
    the sql server equivalent is the SUBSTRING function

    instead of
    Mid([ITEM_NUMBER],2,7)

    use
    substring([ITEM_NUMBER],2,7)

Posting Permissions

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