[sql]
SELECT * FROM names WHERE name like 'Jo% Bloggs'
[/sql]
Not an exact solution (would also return Joseph Bloggs) but good enough for most name lookup screens. It simply ensures the name starts with Jo and ends with Bloggs.