We have a name field which is
surname, name
how can i create a search box that brings up results if they type
name surname
for example - my record is 'Summers, Marc'
if i search for 'marc summers' no records can be found but obviously if i search for summers, marc I come up.

Your help would be appreciated

Best Regards
Marc P Summers
Canterbury City Council