Help..

[paulwalker]

Hi,

Type

A00E

A001

A009

M00E

K009

M09E

How to exclude ending with E
O/p would be

Type

A001

A009

K009

[datanibbler]

Hi Paul,

have a look at String-functions - in particular, LEFT(), RIGHT(), MID()

HTH

Best regards,

DataNibbler

[Nicole-Smith]

Type:

LOAD * INLINE [

Type

A00E

A001

A009

M00E

K009

M09E

]

where right(Type,1) <> 'E';

[qv_testing]

You can use where condition

like this

where right(Type,1) <> 'E';