Results 1 to 2 of 2

Thread: SQL Wildcards

  1. #1
    Join Date
    Aug 2003

    Unanswered: SQL Wildcards

    Hi all this is my first post and probably a simple question but my knowledge isnt great so here goes.

    In access when I start my query I want to search for a record that I specify and preferably part of a recod.

    At the moment my Query looks something like this..

    SELECT Contacts.NameFirst FROM Contacts WHERE ((Contacts.NameFirst Like "*" & [Enter First Name]));

    The problem is this will bring up the data im looking for as long as i dont inlude the first letter. for example if OI wanted to find "station" then "tion" would find my record but "stat" would not.

    It Does however find my record if I type the whole name e.g. "station"

    Any help with this would be appreciated



  2. #2
    Join Date
    Aug 2003
    Soryr if I put this question in the wrong area.

Posting Permissions

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