Hi,
Apologies if this has been asked before, but I've searched the forums and can't find anything.
Question is:
Is there a limit to the number of rows a wildcard selection can retrieve?
I have a large table >10000 rows.
If I write a simple query:
Select count(fieldName) Where fieldName like 'N?*'
This works as expected until there are more than 7502 records beginning with an 'N' then the query returns 0
If I change the where clause to be 'N*' then it seems to work even if there are more than 7502 records to return...
Any ideas please?