Escape asterix (*) in load statement

[#1]

Hi all,

I know this seems a simple question however I haven't been able to find a solution for the following loading only entries that do not contains '*'.

I'm trying to load data from QVD where one of the field (Description) contains '*' along with other characters. I would like to discard any rows with * in the Description. There are many purmutaions of the *.

ex.

*Dennis S

Dennis * Rad

*null (where null) is the string

Any help is apreciated.

Thanks,

T

[jonathandienst · Accepted solution]

T

LOAD ...

     Description,

     ...

From ....

Where Index(Description, '*') = 0;

Regards

Jonathan

[#3]

Thanks Jonathan, This works!