David McDivitt said:
> 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.
ISO standards perhaps?
>>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.
