Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Like 1-9* (WINXP - ACC 97)

    In a query, I would like the criteria to be:
    Records that begin with a numeric value

    I tried :
    Like 1* through 9*
    Like 1*- 9*
    Like 1* to 9*
    Can you please tell me the proper syntax to accomplish this?

    Thank you.

    Sincerely,
    Michael Abrams

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Like 1-9* (WINXP - ACC 97)

    Hi Michael, try

    <code>Like "[0-9]*"</code>

    You can use [ ] to specify a range of characters, for example [A-D] or [N-Z].

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Like 1-9* (WINXP - ACC 97)

    Thank you very much Hans.

    It works perfectly. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Michael

Posting Permissions

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