Forum Moderators: open
WHERE field between 'a%' and 'f%'
this is psudo code. What would be the correct syntax
You could use a substring perhaps ...
WHERE SUBSTRING(columnName FROM 1 FOR 1) BETWEEN 'a' AND 'f';
