Like operator in SQL with Excel Driver
On Jul 23, 5:07*pm, Dick Kusleika wrote:
On Wed, 23 Jul 2008 10:04:24 -0700 (PDT), sonu wrote:
Set rst = New ADODB.Recordset
Sql = "select count(" & Worksheets(wk_xtab).Range("A1").Value & ")
from [MSO_Xtab$A:iv] *where Part_no *= '301971%' "
Shouldn't that be
where Part_no Like '301971%'
--
Dick Kusleika
Microsoft MVP-Excelhttp://www.dailydoseofexcel.com
I tried that also and it does not work either.
|