Please let me know what AN I doing wrong?
I need get records where DELNUMB is missing OR DELNUMB starts with '45....'. It's A10 field.
When I do it separetly, it works. In this case, I'm getting only records where DELNUMB starts not with 45

----------------------------------------
PRINT
DELNUMB AS 'PO'
WHERE DELNUMB EQ '.'
OR EDIT(DELNUMB,'99$$$$$$$$') NE '45'
END

Lera,

Try:

WHERE (DELNUMB IS MISSING) OR (DELNUMB LIKE '45%');

Fernando

P.S. If you example works quickly enough, you could change the NE '45' to EQ '45'.

quote:

PRINT
DELNUMB AS 'PO'
WHERE DELNUMB EQ '.'
OR EDIT(DELNUMB,'99$$$$$$$$') NE '45'
END

Try this Code

quote:

PRINT
DELNUMB AS 'PO'
WHERE DELNUMB LIKE '45%' OR '.'
END

THANKS YOU!