Thanks Chuck and Hardy. The percent sign did it. In all my years doing MS Access and VB I have always used an asterisk, including TSQL on the server. I am curious why this is different. No matter. If it works I'm happy.
>From: Hardy Merrill <[EMAIL PROTECTED]> >Date: Wed, 1 Oct 2003 10:38:06 -0400 >Cc: [EMAIL PROTECTED] > >Just a guess as I have no experience with MS SQL Server, >but LIKE clauses, at least in some databases (like Oracle) >use the percent-sign(%) as the wildcard character. You >might try the percent-sign instead of the asterisk as your >wildcard in the LIKE. > >HTH. >-- >Hardy Merrill >Red Hat, Inc.
