Hi there,

I have not tried your solution, thanks, I will most certainly....

Have tried a function which gives me the result in two columns, but repeats the first value in the...

The following string exists in a filter field called 'dimfilter' in a table called userfilters

DP1201|DP1210|DP1220|DP1230|DP1240|DP1500|DP1510|DP1520|DP1530|DP2301|DP2310..DP2320|DP2340|DP2700|P2710|DP6010|DP6020|DP7000..DP7999

I would like to be able to do the following type of query against these values:

select...

Slowly wading my way through the suggested reading, thanks.....