I guess I should have looked at the code a little closer. ...

Here is what I get:

(13 row(s) affected)

RowNum PartNumber PartRange

----------- -------------------- --------------------

8 ...

Thats really odd. I am working with 2K5. I copied and pasted the code twice and got the same results. It is including numbers outside of the...

Jeff Moden (3/17/2008)

---

biscuit (3/17/2008)

---

Jeff, I did try your code and it worked very nicely. But if you will look at the third resultset, you can see where it...

Jeff, I did try your code and it worked very nicely. But if you will look at the third resultset, you can see where it returned 123456789 and...

Thanks for all the suggestions. The only problem with this is that it returns a part number of 123456789 on a range query of 12300 - 12400. In...

That's a good idea. I need to check all the procs that access that table to see if they will be broken by a new column (I didn't develop...

The range would not generally be that big but the maximum number for a part is 20 characters. I just want to disregard anything beyond the numeric portion of...

thanks guys for all of the suggestions. Since the part numbers are created by humans, there is no set format or any kind of normalization. I've pasted the...

Thanks for the reply. Unfortunately, the data is not uniform enough. one part number might be 100-1023a and another would be 1000000-10b and still another on might be...

That number would be between 100 and 200. basically they want to disregard anything after the first non numeric character and consider that to be the part number. ...

Thanks for the reply... The problem is that say you have a part number of 10001b and you select a range from 1000-2000 it will include the 10001b in...