I am trying to build a Parameterized View, but I want to do a substring
search with 2 parameters.
If cUsrFirstChoice = 'Toolkit', then this works:
where ?cUsrFirstChoice $ cTitle
But if cUsrFirstChoice = 'Toolkit' and cUsrSecondChoice = ''
then this returns no records:
where ?cUsrFirstChoice $ cTitle ;
and ?cUsrSecondChoice $ Subtitle
I was dinkering with macro expansion and the '%' but am coming up dry.