Shifting gears a bit, "mixed" columns such as the one you have are always a pain and hardly ever allow for indexes to be used when using search criteria for numerics. Keeping in mind that there will be the occasional exception (EAVs to store column level changes, for example), my recommendation would be to bring such columns to the attention of whomever it is you work for and suggest that some normalization would be the way to go.