How to search in database

[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'.