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