SUBSTRING Function. Exclude which contains part of the string

[CK_WAKE]

Hi There, I want to apply filter to exclude those records which contains _RE from the Column1 while loading QVD.

Note: Length of strings are not consistent. 

Example I have two columns and  ID is the primary key for the table. So, I want to extract only those records which do not have _RE from column 1 while loading the data.

ID , Column1

1,  A1234_RE

2, A123678

3, A123787910_RE

4, B12384

Please advice.

[BrunPierre · Accepted solution]

Perhaps.

Where not WildMatch(Column1, '*_RE*');

[CK_WAKE]

Thanks for the help, it worked.