i am trying to figure out how to pull the non-mainline items.
for mainline,
CASE WHEN {mainline)='*' THEN
this works...
but i can't get the non mainline
i've tried
CASE WHEN {mainline}=' ' THEN
CASE WHEN {mainline}='' THEN
CASE WHEN {mainline}=null THEN
CASE WHEN {mainline} is null THEN
CASE WHEN {mainline} is not null THEN
CASE WHEN {mainline}!='*' THEN
can anyone help?