Wild card Search in SAP B1

[Former Member]

Dear All,

I need a multiple wild card search under BOM and Production Module.

Let me know any possibilities to do it.

Regards,

Kashinath

[kothandaraman_nagarajan]

Hi,

Try this query,

SELECT T0.[Code], T0.[TreeType] FROM OITT T0 WHERE (T0.[Code] Like '[%0]%%' OR '[%0]' = ' ') and ( T0.[Code] Like '%%[%1]' OR '[%1]' = ' ') and (T0.[Code] Like '%%[%2]%%' OR '[%2]' = ' ')

Regards,

Nagarajan