Counts the number of . (period) characters in the version number
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 101
Takes the second number from the right (and makes it a bigint type). So if the version number is 100.0.1, the code above selects the 0 in the middle.
This should help you decipher the query, because firefox's versions come in different variations, there are quite a few where clauses. There are versions with 1 period in it. Versions with 2 and also versions with 3 periods in it (thanks Microsoft store app).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.