Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    7

    Question Unanswered: Substring with Access

    Hi,

    I'm using Delphi, ADO and Access 2000. I just want to do a substring in my where statement like :

    delete from test_inspection
    where substring(no_test_code, 1, 1) = '3'

    The substring function doesn't seem to work. What is the ringht function? I will have done this with Oracle and it will have taken 30 seconds to do but currently, I'm not able to find the right function to call to do that.

    Thanks

  2. #2
    Join Date
    Apr 2004
    Posts
    7
    Forget it, we must use MID. The problem is that there is nothing in the Access help system that say so.

Posting Permissions

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