[RBG7-L] - Is this okay to do??

[Dan Goldberg]

I need to do a between clause on a text field.

select partnum where partnum between '000' and '050'

Is it okay to do:

select partnum where (int(partnum)) between 0 and 50

Doe anybody know of any issues in doing it like this??

Dan Goldberg