The website I am working on need to search name by first two letters of last name. The name is in a single field in the database called 'name', so the
String would be 'Bob Smith', and the user would type in 'SM' and look for a match. How would I do this? I'd prefer to do it in an SQL Query entirely, but if I have to do some code manipulation that is possible too.

Thanks.