Re: EOModel SQL Statement
Re: EOModel SQL Statement
- Subject: Re: EOModel SQL Statement
- From: Benjamin Chew <email@hidden>
- Date: Tue, 6 Apr 2010 11:18:37 -0700
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
<email@hidden> 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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden