I'm trying to do a software update against older version of software. Unfortunately, the software version is stored in the SQL table as type "nvarchar" with data similar to:
I am trying to update the version 3 software and my query was
where Version < "3.12.1"
which finds nothing because 3.2 is greater than 3.1.
So I guess i will need to convert the string to a number ? or how would you go about this?
offhand, I would have to convert to three numbers (major, minor, other minor). Surely there has to be an easier way than this.