Skip to Content
avatar image
Former Member

Wild card Search in SAP B1

Dear All,

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

Let me know any possibilities to do it.

Regards,

Kashinath

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 22, 2017 at 07:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded