Results 1 to 6 of 6

Thread: Begins With

  1. #1
    Join Date
    Jul 2003
    Posts
    6

    Unanswered: Begins With

    I am trying to reduce the number of fax numbers I have in my access database querying out all numbers except 6 area codes.

    I have tried to do:

    SELECT FaxNumbers
    FROM FAXList
    WHERE FaxNumbers BEGINS WITH 972 OR 817 OR 214;

    but it doesn't work, what am I doing wrong?

  2. #2
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Correct Query

    Hi
    Try the following query

    select phone from users where phone like '301%' or phone like '201%' or phone like '212%';
    Thanx and Regards
    Aruneesh

  3. #3
    Join Date
    Jul 2003
    Posts
    6

    LIKE %

    I have tried both the command BEGINS WITH 972 or 817 or 214 or 903 and LIKE 972% or 817% or 214% or 903%, and neither work. I get no results even though I know that there are some in there.

    Can anybody help me?
    Gurka

  4. #4
    Join Date
    Jul 2003
    Location
    US
    Posts
    314
    Could u post the command u r using to query the DB.

  5. #5
    Join Date
    Jul 2003
    Posts
    6
    I think I got it to work.
    I used * instead of %.

    Gurka

  6. #6
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    GOOD LUCK

    Gurka
    Good luck with your query.
    Aruneesh

Posting Permissions

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