Hi, I have noticed that it is hard to acheive the count (distinct a) command in sqlite. However, I have tried the suggested work around by:
SELECT count(ticker) FROM (SELECT DISTINCT ticker FROM ListDetail WHERE TableName LIKE "sixty%" AND Ticker <> "" This is also giving an error, is there any way to work around this as well? (If the LIKE operation is omitted the query functions 100%.) regards, Jonas
