mdbtools
mdbtools copied to clipboard
sql COUNT with LIKE
Is this a bug or a feature request?
This works
select COUNT(*) from Shippers
and this works
select * from Shippers where CompanyName Like '%Pack%'
but this does not
select COUNT(*) from Shippers where CompanyName Like '%Pack%'
via isql it returns
SQLRowCount returns 0
and via mdb-sql it returns multiple blank lines with final line of
1 Row retrieved
Well it's a bug in that the syntax returns an unexpected result. But implementation will be a small feature. I'll label it and keep it open.