SAP中的通配符和转义符

通配符: *、+

转义符：#

 

OPEN SQL中：

通配符: %、_

转义符可以使用ESCAPE关键字来定义，如：

SELECT SINGLE * FROM makt WHERE spras = 1 and maktx LIKE '%/_' ESCAPE '/' .

 

字符串操作关键字中:

通配符: *、+

转义符：#(CP操作符专用)

 

如：

REPORT  z_barry_test.

PARAMETERS: P_INPUT(10) TYPE C LOWER CASE.

IF P_INPUT CP '#S#A#P123'.
WRITE:/ 'YES'.
ELSE.
WRITE:/ 'NO'.
ENDIF.

 

OR:

 

REPORT  z_barry_test.

PARAMETERS: p_input(10) TYPE c LOWER CASE.

DATA: r_compare TYPE RANGE OF text10 WITH HEADER LINE.

r_compare-sign = 'I'.
r_compare-option = 'CP'.
r_compare-low = '#S#A#P123'.
APPEND r_compare.

IF p_input IN r_compare.
  WRITE:/ 'YES'.
ELSE.
  WRITE:/ 'NO'.
ENDIF.

 

ZL_SX00_PS_Project_Manager

转载于:https://www.cnblogs.com/JackSun/archive/2011/11/08/2241631.html