Using * and ASP

Results 1 to 3 of 3

Thread: Using * and ASP

  1. #1
    Kate Guest

    Default Using * and ASP

    How do I gets an SQL search using "Like "*....*" to work in ASP<BR>eg<BR><BR>SELECT Hotels.HotelID, Hotels.HotelName, Hotels.Description, Hotels.Town<BR>FROM Hotels<BR>WHERE (((Hotels.Town) Like "*St. Andrews*"));<BR><BR>This won&#039t work in my asp code.<BR>Is there an alternative way to do this?<BR><BR>please help ,<BR>Kate

  2. #2
    Join Date
    Dec 1969

    Default RE: Using * and ASP

    Use % not *. That should do it. Also, you have one to many ().

  3. #3
    Gumman Guest

    Default RE: Using * and ASP

    Hi <BR><BR>I&#039m wondering how I can do a textsearch through a field in my SQL db with part of words, If I try to find a word with the letters apa in the middle or in the end of it or a sentence with apa in it.<BR><BR>Can you help me please<BR><BR>//Gumman

Posting Permissions

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