My Query......I am writing an IF statement. I am looking into a field in the report, and if the text in that field matches my example, it writes something in a new field.

eg...

 

WhilePrintingRecords;
StringVar CONN;

 

if ({Piping.SHORT_DESC} = "PIPE")
    then (CONN := "BE")
    else if ({Piping.SHORT_DESC} = "WT")
    then (CONN := "BW")
    else if ({Piping.SHORT_DESC} = "WTR")
    then (CONN := "BW")

    else (CONN := "-")

 

To cut the code down I just want to capture all the items starting with W (WT & WTR) and assign them to BW.

 

Sooooooooo easy when you know how