Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
SQL SELECT * FROM PRODUCT WHERE INSTR(ITEMNUMBER, '.') = 0;
try below
SQL SELECT *
FROM PRODUCT
WHERE ITEMNUMBER NOT LIKE '%.%';
Thanks for advice