Is there a way to join tables on one field that represents a series of valid values? For example, one table has a number or string with "51234" and the other has something like "46610..46680|48670|50000..54280|48240". If there isn't a way to directly join these, is there a way to convert that series to rows with each number in it for a table variable or something like that?

That series column is being generated from Dynamics Nav 5.0 SP1 for general ledger accounts being mapped to departments. I have very little experience with that system, and a LOT of what we have was customizations that a third party was contracted to do, so that may or may not even be standard... I don't even have direct access to the database for that either, but as far as I can tell, that series is being stored as a varchar(100).

I've searched around a lot, but I haven't seen anything like what I need to do. Hopefully someone here has some ideas..