What about the following select statement:
SELECT * FROM insurance WHERE LEFT(po_name,2) >= 'SI' AND (LEFT(po_name,6) <= 'SMITH ' OR LEFT(po_name,6) <= 'SMITH*')
Your left statement will always be the length of the start string for the first part and the length of the second or ending string plus 1 for the second part of the statement.
But how do you know if they are entering all or part of a name?
Does this make sense?
Vicki Combs
Customized software for today AND tomorrow...
Applications and web sites designed, developed and maintained. (MBE)
"Change is inevitable...unless that's changed!