Results 1 to 4 of 4

Thread: sql and keyword search

  1. Jun 14th, 2000, 10:11 PM #1
    Negative0
    Negative0 is offline

    Thread Starter
    PowerPoster 2.0 Negative0's Avatar
    Join Date
    Jun 2000
    Location
    Southeastern MI
    Posts
    4,367

    The Like Command

    In your Like call you need to use wildcards.

    Such as "txt1 like '*" & textbox & "*'"
    Negative 0

    Blog | RegEx | Encrypting UN/PW in Web.Config | Enabling ASP.Net on IIS 6 | Port Numbers | Creating GUIDs | Start->Run | Modifying the default class



    Reply With Quote Reply With Quote
  2. Jun 15th, 2000, 03:55 PM #2
    csingeu
    csingeu is offline
    New Member
    Join Date
    Jun 2000
    Posts
    4
    Actually I'm also facing this problem...
    and but my problem is ...
    i already included the wildcards

    SQLString = "SELECT * FROM Main WHERE Name LIKE ('*John*')"

    but it still cannot work with ado dc ..
    btw, I using access2000 and the ado dc is bound to a datagrid.
    Reply With Quote Reply With Quote
  3. Jun 15th, 2000, 04:42 PM #3
    Richyrich
    Richyrich is offline
    Addicted Member
    Join Date
    May 2000
    Location
    London Occupation: Desktop Developer
    Posts
    141

    ADO...

    Not an expert with ADO however I do beleive that the wildcard character is a '%' not a '*' .
    Reply With Quote Reply With Quote
  4. Jun 15th, 2000, 11:30 PM #4
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    The wildcard depends on if the the DBMS is ANSI standard...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width