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.
Printable View
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:
Gets any records in table1 where somename starts with 'ar'.Code:SELECT * FROM Table1
WHERE SomeName LIKE 'ar%'