Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

EOModel SQL Statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

EOModel SQL Statement

Subject: EOModel SQL Statement
From: Gino Pacitti <email@hidden>
Date: Tue, 06 Apr 2010 15:48:22 +0100

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


Follow-Ups:

Re: EOModel SQL Statement
From: Benjamin Chew <email@hidden>
Re: EOModel SQL Statement
From: Chuck Hill <email@hidden>


Prev by Date:
Re: [OT] help moving server to new IP

Next by Date:
WOCommunity Maven repository is down again

Previous by thread:
Re: [OT] help moving server to new IP

Next by thread:
Re: EOModel SQL Statement

Index(es):

Date
Thread