mdbtools icon indicating copy to clipboard operation
mdbtools copied to clipboard

sql COUNT with LIKE

Open kalpha2 opened this issue 4 years ago • 1 comments

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

kalpha2 avatar Feb 04 '21 09:02 kalpha2

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.

evanmiller avatar Feb 04 '21 13:02 evanmiller