If the numeric suffix is the only part of the policy number that changes, then you can use:
WHERE PolicyNumber >= 'KD/FGH/3345/NNN/1000' and PolicyNumber <= ' KD/FGH/3345/NNN/1090' Ben On Tue, Apr 6, 2010 at 7:48 AM, Gino Pacitti <ginok...@mac.com> wrote: > Can someone help with a SQL statement to return rows... > > I have a field (varchar) which is used to store a PolicyNumber - something > like KD/FGH/3345/NNN/1000 > > They are stored sequentially and go up to KD/FGH/3345/NNN/5000 > > I need to select a set that is something like KD/FGH/3345/NNN/1000 - > KD/FGH/3345/NNN/1090 > > I have tried using a SQL statement that uses BETWEEN and LIKE and <= etc.. > but I cannot get a statement to return the 90 rows between 1000 - 1090.. > > Can someone help? > > Gino > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > > http://lists.apple.com/mailman/options/webobjects-dev/bchew%40smarthealth.com > > This email sent to bc...@smarthealth.com >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com