Like in load statement, multiple matches

[Mt3]

Hi,

I am trying to figure out what the like statement could be incorporated within the load statement with many matching options.

What i would like to sort is all results, which contain letter A or B.

I tried wildmatch and like statement, but both results are not correct. 

Would you have any suggestions on that?

LOAD
"ColumnName"
FROM [qvdlocation.qvd]
(qvd)

WHERE "ColumnName" like '%A%' or '%B%';

[brunobertels]

hi 

may be this 

LOAD
"ColumnName"
FROM [qvdlocation.qvd]
(qvd)

WHERE match("ColumnName" ,'*A*' ,'*B*') ;

[SunilChauhan]

I think it's required wildmatch

hi 

may be this 

LOAD
"ColumnName"
FROM [qvdlocation.qvd]
(qvd)

WHERE wildmatch("ColumnName" ,'*A*' ,'*B*') >0;