comparing integers within string values
I have some string values stored in a database table for the screen sizes of laptops like 14 inches, 15.6 inches, 16 inches and so on. These values are being searched using an advanced search option which uses a range of values like:
less than 14 inches
How can I use the above search criteria to get the values from the database to show me all the screen sizes that lie within the range:
I have tried using comparison operators but the correct results are not shown. It either shows the starting values or the ending values. Not the ones in between the range.
Please help me out on this as I require this urgently.
Thanks in Advance