Strange Query Problem

Results 1 to 3 of 3

Thread: Strange Query Problem

  1. #1
    Jason Guest

    Default Strange Query Problem

    I am using an Access DB for my website. The query below returns no records, yet when I copy and paste it into Access and run the query, it returns results. Am I doing something wrong in my SQL statement?<BR><BR>Select * From Members Where LastName Like &#039;s*&#039; <BR><BR><BR>Thanks

  2. #2
    Kasper Guest

    Default Stranger things have happened...

    Use % instead of *

  3. #3
    Jason Guest

    Default RE: Stranger things have happened...

    That worked but I thought that was only used for SQL Server. Strange... Thanks

Posting Permissions

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