[Tezuka]

say i have 1field with range of 0 to 99
i need to pick out a range between 14 to 20.
anyone able to help with what commands to use.
i set the starting point ie. sDD>='14'
but nto sure how to cast the eDD to 20 so it only read from the database in the range of 14 to 20

[brendandonhu]

sDD>='14' LIMIT 6;

Is that what you're looking for?

[Tezuka]

np
i figured it out

i use BETWEEN

eg. between sDD and eDD
where sDD and eDD can be anyvalue of 0to99

but now my problem is.
if my eDD is smaller than my sDD
it would not pickup.