You didn't follow my example, and field names can not have spaces
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
"chaolu" <(E-Mail Removed)> wrote in message
news:07420883-B34E-47A2-BD3A-(E-Mail Removed)...
> Sorry, I wasn't able to access the web to respone. This does not work. It
> did not find any record from the database.
>
> I was using :
> Select * from myDatabase where "chk name" Like '%" & "Chk name" & "%'
> Also
> Select * from myDatabase where "chk name" LIKE '%" & ''chk name'' & "%'
> Also
> Select * from myDatabase where "chk name" LIKE '%" & ''::chk name'' & "%'
>
> None of them work. Just another question, does it matter that if there is a
> " " between the "chk name" and the second '&'. I also using two ' when I use
> ::chk name::
>
> Thanks for your help!
>
>
> "Thomas A. Rowe" wrote:
>
>> Try:
>>
>> Select * from My_database where check LIKE '%" & check & "%' "
>>
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "chaolu" <(E-Mail Removed)> wrote in message
>> news:C12FA479-6372-4197-9089-(E-Mail Removed)...
>> > ?How to design a pattern search in MS Access database from FrontPage? I have
>> > custom SQL code :
>> > Select * from My_database where "check" like '*::check::*'
>> > This does not work.
>> >
>> > Select * from My_database where "check" = '::check::'
>> > This work.
>> >
>> > So, I know all the database connection or select statement works fine.
>> > Can export tell me how to make a 'pattern search' work with MS Access
>> > database through FrontPage?
>> >
>> > Thanks!
>> >
>> >
>>
>>
>>
Similar Threads
