#1
  1. No Profile Picture
    hum...
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Location
    Brazil
    Posts
    24
    Rep Power
    0

    Question SELECT search in JetSql 4 using case-sensitive


    My problem is like this:

    http://www.4guysfromrolla.com/webtec...022400-1.shtml

    But I use ASP + Access (Jet SQL 4)

    Please, help me...
  2. #2
  3. No Profile Picture
    Overly white
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Location
    Fresno, CA
    Posts
    83
    Rep Power
    12
    Um I really have no idea on this one. A work around would be to have a query like so
    Code:
    SELECT tblName.fname FROM tblName WHERE fname = "Defjamninja";
    Then use asp to find the exact match you are looking for.

    Code:
    For intI = 0 to recordset.count - 1
      If recordset.fields("fname") = "DEFJAMNINJA" Then
        Response.write("FOUND")
        exit for
      End If
    Next
    The problem with this is that if your query returns a lot of records then this could become slow.

IMN logo majestic logo threadwatch logo seochat tools logo