What DB are you using? Different DBs use different wildcards. If it's access you want the * that Ganeshmoorthy suggested. For SQL Server you use %. Other DB's use different wild cards again but most use one of these two characters.