It used to work as a text before I changed the index. When I created a multi-column unique index it does not work anymore. It is not a 7.0 problem because it also does it in 6.5.
So now I must change my code so it will work again. As far as the 050 and 0050 I do not have that problem...right now but thanks for enlightening me on that. I did not think of that. Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dawn Oakes Sent: Wednesday, August 04, 2004 8:57 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Is this okay to do?? 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
