in reply to Using DBI to create 'loose' search options with LIKE and %

You're missing quotes around %name% in $sth->execute, apart from that the code is OK.

rdfield