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
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.