Lists

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

Re: EOModel SQL Statement

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

Re: EOModel SQL Statement

Subject: Re: EOModel SQL Statement
From: Chuck Hill <email@hidden>
Date: Tue, 6 Apr 2010 10:42:41 -0700


On Apr 6, 2010, at 7:48 AM, Gino Pacitti 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?

WHERE PolicyNumber like 'KD/FGH/3345/NNN/10%' should give you from KD/ FGH/3345/NNN/1000 to KD/FGH/3345/NNN/1099. Not exactly what you wanted.

--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects

_______________________________________________
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



References:  
  >EOModel SQL Statement (From: Gino Pacitti <email@hidden>)




Prev by Date:
[OT] WOWODC room block

Next by Date:
Re: EOModel SQL Statement

Previous by thread:
EOModel SQL Statement

Next by thread:
Re: EOModel SQL Statement

Index(es):

Date
Thread