Expression filter to sql code

HI

 i  have a question about transform expression filter  like this   :  600001..600450|899005|879051..891560|745000|745800   

 to a sql filter 

i want transform this value automaticaly in sql filter because i have a table in navision where a column stored different expression filter to group account

do you know a method to do this

for example, in the columm i have this value for account : 600000…600150|610002|610008|700000…700008

and i want create this where condition
account between 600000 and 600150
or
account between 700000 and 700008
or
account =610002
or
account = 610008

Thanks

best regards

You should be able to use the RANGE and OR statements in SQL. Format the RANGE statement as follows:

SELECT number FROM RANGE(600000, 600150) OR RANGE(700000, 700008) and so on.

Ok

but my question is :

does a sql procedure or a sql parser exist where i can post a parameter that contain the value 600000…600150|610002|610008|700000…700008 and maybe the name of the column (account) to obtain automatically this result :

account between 600000 and 600150
or
account between 700000 and 700008
or
account =610002
or
account = 610008

or this result

account in ( 600000 , 600001,…,600150, 6100002,610008, 700000,7000001,…)

(warning with the limitation of values in the in expression)

thanks