hi there..

I need help. I use visual basic 6. I want to make program that can search text in one database (SQL). that text can be as record or field.

in one database there is many table, so I want to make program that can search for a text in each record in each fieldname in each table in one database, can I?
also, I want search for a text in each fieldname in each table in one database, can I?

Database is stored in sql 2000.
thanks before