Exclude specific records from a SQL call

[JACKNIEKERK]

Reading a datafile on 1 key,   ITEMNUMBER,   

contains numbers like  12345678  but some like 12.345678

  need syntax to say like

SQL select * from PRODUCT  where ..........................ITEMNUMBER   does not contain a   '.'  (dot)  

thanks for advice

[sunny_talwar]

May be this

SQL SELECT * FROM PRODUCT WHERE INSTR(ITEMNUMBER, '.') = 0;

[JACKNIEKERK]

Hello got error

SQL##f - SqlState: 37000, ErrorCode: 0, ErrorMsg: [Pervasive][ODBC Client
Interface][LNA][Pervasive][ODBC Engine Interface]Invalid scalar function:
INSTR.
SQL SELECT * from PRODUCT WHERE INSTR( ITEMNUMBER ,'.')= 0

[Kushal_Chawda · Accepted solution]

try below

SQL SELECT * 
FROM PRODUCT 
WHERE ITEMNUMBER NOT LIKE '%.%';

[JACKNIEKERK]

Thanks for advice