Friday, March 30, 2001 01:29 AM
for example if you want to search the name of an employee in the database (Eg:- table name EMP_MASTER and field name EMP_NAME )then the query will look like as below
SELECT EMP_NAME FROM EMP_MASTER WHERE EMP_NAME LIKE %(STRING)%
This will give you all the names containing the string passed as the parameter..
I hope this would solve your problem.
If you still find a problem then mail me back .. I will expalin you in detail.