KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have firmware version strings into my table (like "4.2.2" or "4.2.16") How can I compare, select or sort them ? I cannot use standard strings comparison : "4.2.2" is a seen by SQL greater than "4.2.16" As version strings, I would like 4.2.16 to be greater than 4.2.2 I would like to consider that firmware version can have chars in them : 4.24a1, 4.25b3 ... for this, usually, the subfield with chars has a fixed length. how to proceed ?
Tags (comma-separated)
Save Edits
Cancel