I want to conduct a search in SQL table using like command.
With the content is 250.xx, it is easy, like:
select count(number) from table1 where value1 like '250%'
With (410.xx-414.xx), I can use:
select count(number) from table1 where value1 like '41[0-4]%'
But I have problem conduct it on these below range:
,492.8, or 496);
range2 ( 398.91,402.01,401.11,402.9
range3 (401.00, 401.1, or 401.9 and without range2
Could you please help me in these ones.
Thank you very much!