PDA

Click to See Complete Forum and Search --> : DB Question


Dayo312
Jan 11th, 2000, 07:17 AM
I Already have a system set up to find a Field in the database, What I need to know how to do is to find the next match the has the same Word in the field as the last.
How could I do this?? Thankyou!

Evan

LG
Jan 11th, 2000, 09:42 AM
Hi, Evan.

This sql statement will return all matching records from a table:

sql = "select * from categories where description like " & Chr(34) & chr(42) & Text1.Text & Chr(42) & Chr(34)

Chr(34) is ""
Chr(42) is *

Larisa