Egg
Sep 23rd, 2000, 03:14 AM
A question regarding SQL using Jet OLE DB 4.0
I am trying to execute the following...
With rsSearch
'Get the number of records in the table
.Open "Select * From " & sTable & "Where " & _
sField & " Like '#_' Escape '#'"
dbDatabase, _
adOpenKeyset, _
adLockOptimistic
etc...
The escape character does not work any solutions?
I am trying to execute the following...
With rsSearch
'Get the number of records in the table
.Open "Select * From " & sTable & "Where " & _
sField & " Like '#_' Escape '#'"
dbDatabase, _
adOpenKeyset, _
adLockOptimistic
etc...
The escape character does not work any solutions?