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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
