如何使用SQL Server比较软件版本？

When trying to compare software versions 5.12 to 5.8, version 5.12 is newer, however mathematically 5.12 is less than 5.8. How would I compare the two versions so that a newer version returns 'Y'?When trying to compare software versions 5.12 t