Search like

Results 1 to 2 of 2

Thread: Search like

  1. #1
    Join Date
    Dec 1969

    Default Search like

    how do i create a sql statement to the database for alike???<BR><BR>i have a var that holds number<BR><BR>Search = 3<BR><BR>sql = "SELECT * FROM Product WHERE BTU LIKE Search" <BR><BR>I tried with the above sql statement.. but does not work.. why??

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Search like

    &#062;SELECT * FROM Product WHERE BTU LIKE Search" <BR><BR>what is search??<BR><BR>If you are looking for the string "search" <BR>SELECT * FROM Product WHERE BTU LIKE &#039;%Search%&#039;" <BR><BR>IF you bothered to look at ANY help on like as far as SQL was conserned you would have know this.<BR><BR>

Posting Permissions

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