No - but Why? I would think that leaving the where clause with the text values should give you the proper results. Do you have partnums that are '050' and '0050'? If so - they're going to both be 50 when you convert them to integers. Could be a problem depending on what you're doing.
-----Original Message----- From: Dan Goldberg [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 11:48 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Is this okay to do?? 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
