Excluding records with symbols

[#1]

Hello,

I am loading data from a database but since there is alot of records i want to filter the records that contain a symbol.

The following symbols i want to exclude:

*, /, #

I tried the following:

[Example]:

LOAD

     [KeyPart]

SQL SELECT

FROM Database

WHERE [KeyPart] NOT LIKE '*'

[tresesco]

Try something like this:

[Example]:

LOAD

     [KeyPart] ;

SQL SELECT  [KeyPart]

FROM Database

WHERE Not (Instr([KeyPart], '*') Or Instr([KeyPart], '/') Or Instr([KeyPart], '#'));

Edit: Corrected some basics

[#3]

try this

[Example]:

LOAD

     [KeyPart]

WHERE not match([KeyPart], '*','/','#');

SQL SELECT

FROM Database;

[#4]

I am using an Informix database and with both solutions I get an OCBD db error

[CELAMBARASAN]

Try with this

[Example]:

LOAD

     [KeyPart]

SQL SELECT

FROM Database

WHERE [KeyPart] NOT LIKE '\*'

Can you tell me these symbols are part of a string? if so use WHERE [KeyPart] NOT LIKE '%\*%'