Like Statement

[strom99]

I have the following:

= If Match(<Keyword> ,"CC:BEF") Then "BEF" Else If Match(<Keyword> ,"CC:HANDHELD") Then "HANDHELD" Else If Match(<Keyword> ,"CCBEF") Then "DBEF" Else If Match(<Keyword> ,"CC:ESR/DESR/DRPF") Then "ESR/DESR/DRPF"

Using BO 5.1.7

This variable works if the "CC:BEF" etc is at the start of the keyword field, it won't display the THEN if the CC:BEF falls anywhere else in the keyword field...how can I get this to work? Thanks Much!!

 

[Madawc]

Can the values be null? Nulls stop any formula, unless you first test for IsNull(value)

Madawc Williams (East Anglia, UK)