I need to select the value between 5.0.1.0 to 5.0.12.0:
Create table Test (id int, value varchar(20)); Insert into Test values(1,'5.0.11.0'),(2, '5.0.100.0'),(3,'5.0.14.0'),(4, '5.0.5.0'),(5, '5.1.1.0'),(6,'5.0.12.0'),(7,'5.0.10.2)');
Id Values 1 5.0.11.0 2 5.0.100.0 3 5.0.14.0 4 5.0.5.0 5 5.1.1.0 6 5.0.12.0 7 5.0.10.2
My output I need:
Id Values 1 5.0.11.0 4 5.0.5.0 6 5.0.12.0 7 5.0.10.2
Thanks.