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