Try the CONTAINING keyword, a la:

select * from empinfo_history
where lastname containing 'Ar'

Returns both Clark and Arnold, for example.

As CONTAINING is case-insensitive, the following two return the exact same
result sets.

select * from empinfo_history
where lastname containing 'AR'

select * from empinfo_history
where lastname containing 'ar'

Clay Shannon,
Dimension 4 Software