i am using vba code and database sql 2000

how to searching data from database (already stored some data)

example:

if user knows only half of the file name (file alise
fileinformation,filename,etc )

this file name give to txtbox=fil after click ok button
it will show all related fil files.
any possible, please give some code