Sort query results by input

[szlamany]

You might be able to actually order by that CHARINDEX value as well - have you tried that?

ORDER BY charindex(VerID,'00101001,00201001,00101002')