Skip to Content
0

Wild card Search in SAP B1

Jun 22, 2017 at 06:31 AM

30

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nagarajan K Jun 22, 2017 at 07:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded