Like Statement

[Steve95]

Hi All

I am doing web stats and have url code where I am looking for lines which contain 2 words, so I the code I written is:
if {URL.field} like ['*redirect*','*tailoredextranet*'] then 1 else 0

But this is not bringing the correct resultset I need to see both (redirect and tailoredextranet) words in the url hence =1 else 0. So I need a 'and' statement somewhere....I dont know where..been a long hard day....

Please can you help....
tc

 

[lbass]

Try:

if {URL.field} like '*redirect*' and
{URL.field} like '*tailoredextranet*' then 1 else 0

Or you could use:

if instr({URL.field},'redirect') > 0 and
instr({URL.field},'tailordextranet') > 0 then 1 else 0

-LB