Instead of using LIKE use '<' to get a count of records before the one your
targeting. Something like this would work (names are from my schema):
SELECT PermissionRef
FROM LU_Permissions
LIMIT 10
OFFSET (
SELECT COUNT(*)
FROM LU_Permissions
WHERE PermissionRef < 'Sc');
HTH,
Sam
-------------------------------------------
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
