syntax for wildcard

Results 1 to 3 of 3

Thread: syntax for wildcard

  1. #1
    aimskee Guest

    Default syntax for wildcard

    What is the SQL syntax for finding a string within a field using ASP with MSAccess?<BR>When I used AND CONTAINS(descript,&#039;desk items&#039;) for instance, where descript is a field and desk items is my literal string, I am getting an error.<BR>Please help!<BR>aimskee

  2. #2
    Join Date
    Dec 1969

    Default Use LIKE....

    Like &#039;%" & YourKeyWord & "%&#039;

  3. #3
    aimskee Guest

    Default RE: Use LIKE....


Posting Permissions

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