SQL wildcards

Results 1 to 3 of 3

Thread: SQL wildcards

  1. #1
    fl1rt@chee.ky Guest

    Default SQL wildcards

    hello again...<BR><BR>I need to do a database search where wildcards are a feature eg..<BR><BR> StrSQL = "SELECT * FROM Directory where city=LON*"<BR><BR>LON* is a wildcard for any city with the prefix LON<BR><BR>like LONDON<BR><BR>cheers, unless I solve it first<BR>I&#039m sure it&#039s easy...it&#039s just 02.30am in the morning here..yawn<BR><BR>

  2. #2
    Sharique Guest

    Default RE: SQL wildcards

    HI there!<BR><BR>Do not use <BR>StrSQL = "SELECT * FROM Directory where city=LON*"<BR><BR>USE<BR>StrSQL = "SELECT * FROM Directory where city like %LON% "<BR><BR>Thank U.

  3. #3
    fl1rt@chee.ky Guest

    Default wild and cool..easy when you know how

    thanks..Sharique<BR><BR>that syntax for wildcards worked a treat.<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