Select statement

Hello,

How can I write this select statement:

select OprId from RouteOpr where OprId not like ‘%KPG’

in X++?

Try this statement

select OprId from RouteOpr where !(OprId like 'ob-fo’)

Thanks

It’s work