Thread: Like operator in SQL with Excel Driver
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
  
Posts: 595
Default Like operator in SQL with Excel Driver
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-Excel
http://www.dailydoseofexcel.com
Reply With QuoteReply With Quote