Is there any way to use the Instr (Like)
Is there any way to use the Instr (Like) together with an IN equivalent? I am trying:
with set prec as nonempty (([Yahoo Advertiser].[Advertiser Domain].children))
select [Measures].[Click Count] on 0,
(filter(prec, instr(1, [Yahoo Advertiser].[Advertiser Domain].currentmember.name, [Sites].[Site Name].currentmember.name)0)) on 1
from financials
Basically, I want to get all the advertiser domain members that resemble site name members. Thanks!