[。解析失败，因为输入字符串“1.1.3”不是sqlhierarchy yid节点的有效字符串表示形式

I have created a VARCHAR column named 'SequentialOrder' in one of my SQL Server tables. It holds the version number of an application, in the format 'MajorVersion.MinorVersion.RevisionVersion', e.g. '2.5.1'. I want to retrieve the contents of this table and sort them by the AppVersion number in a descending order, so that the latest version is on top. column named 'Sequenti