How to search in database

[srichakram]

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.

[JemimaChadwick]

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.

[JoshT]

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

SELECT * FROM Table1
WHERE SomeName LIKE 'ar%'

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