How to search in database

When a text is being specified in a text field like "ar", database needs to be searched for a bookname starting with "ar" or any book name with that word.

How about usign this Query, provided its SQL Server u r using....

Select BOOK_NAME from TABLE where TEXTFIELD like "%ar%"

Note: Pls change the Words in Capitals to the appropriate values in the Select Query

Hope this helps.
- Jemima.

Use your database's wildcard character (* for Access, % for SQL Server, etc) which the LIKE statement:

Code:

---

SELECT * FROM Table1
WHERE SomeName LIKE 'ar%'

---

Gets any records in table1 where somename starts with 'ar'.