处理有多个like查询并且带有区间查询的科目

1.业务需求如图所示：

 

 

业务描述：我需要查询出如上图所示的带有多个like，多个区间，和多个明细科目的sql实现逻辑。（注意：区间的*可以用0000或者00来进行补全）

2.主要是处理财务的问题，sql不会写，现在问题解决了如下代码：

AND (
ONE.RACCT LIKE '222101%'
OR ONE.RACCT LIKE '222102%'
OR ONE.RACCT LIKE '222141%'
OR ( ONE.RACCT BETWEEN '2221030300' AND '2221031300' )
OR ( ONE.RACCT BETWEEN '2221040000' AND '2221200000' )
OR ( ONE.RACCT BETWEEN '2221340000' AND '2221390000' )
OR ONE.RACCT IN ( '2221310000', '2221410000', '2221500000', '2221510100', '2221510200', '2221510400' )
)