Problem as above, please help thank you.

CodePudding user response:

Case the when substr (' 4.25 'instr (' 4.25', '. ') + 1) between 19 and 25
Then 500 end

CodePudding user response:

Select a case when substr (date, 3, 2) & gt;=19 and substr (date, 3, 2) & lt; Number=25 then as 19-25, date, quantity from the table