Results 1 to 2 of 2

Thread: help with query

  1. #1
    Join Date
    Feb 2004
    Posts
    106

    Unanswered: help with query

    What is the function in Access to check for value of 4th character in a text field.

    For example, I need the query to return all records where the field has 4th character equal ".".

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    SELECT ... FROM ... WHERE (Mid(SomeText,4,1)='.'));
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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