Results 1 to 2 of 2

Thread: DB Question

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 1999
    Posts
    184

    Post

    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

  2. #2
    Hyperactive Member
    Join Date
    Jun 1999
    Posts
    308

    Post

    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width