>>VFP table. And I think the last select I posted should do it.
>
>Then why in your post DB is set to SQL Server? :-)))))))))))))))))

Forgot to change from my defaults :)

>O!!!!!
>I just saw that you reverse FROM and JOINed tables :-))))))))))))))
>
>Two things:
>Put OptionsId also in JOIN condition (I didn't see it)
>Use [_1_12_] pattern because when you want ModelId 1 you will get ALL that have [1] in the number 1, 10,11..19,21 etc.

Yes, agree - I was just building it based on your idea. I would use some delimiter, sure.

Thanks a lot again for your help - now I need to finish reading VPM Help and will be ready to try it.

And, of course, ISNULL -> NVL()