ABAP coding

[Shiva_Ram]

Hi,

In our ABAP program one of the line is coded with XBLNR LIKE '%MISC%'. How should I interpret this line? The XBLNR value should contain MISC only or it can be like 11111111MISC? What should I note when look for value XBLNR?

Thanks for the clarification.

[Former Member]

Hi,

The XBLNR value can be 'ACC<b>MISC</b>AC'..

OR

'<b>MISC</b>AC'

OR

'asd<b>MISC</b>'.

Thanks,

Naren

[Former Member]

Comparing Strings

To find out whether the value of a column matches a pattern, use:

SELECT ... WHERE <s> [NOT ] LIKE <f> ...

You can use the following wildcard characters in <f>:

<b>% for a sequence of any characters (including spaces).

_ for a single character.</b>

For example, ABC_EFG% matches the strings ABCxEFGxyz and ABCxEFG, but not ABCEFGxyz. If you want to use the two wildcard characters explicitly in the comparison, use the ESCAPE option. ESCAPE <h> specifies an escape symbol <h>. If preceded by <h>, the wildcards and the escape symbol itself lose their usual function within the pattern <f>. The use of _ and % corresponds to Standard SQL usage. Logical expressions elsewhere in ABAP use other wildcard characters (+ and *).

Regards,

Srikanth

[Former Member]

Hi shiva,

the string should contain XBLNR