xywuyiba6 发表于 2015-9-22 07:34:06

SAP中的通配符和转义符

通配符: *、+
转义符:#

OPEN SQL中:
通配符: %、_
转义符可以使用ESCAPE关键字来定义,如:
SELECT SINGLE * FROM makt WHERE spras = 1 and maktx LIKE '%/_' ESCAPE '/' .

字符串操作关键字中:

通配符: *、+
转义符:#(CP操作符专用)

如:
REPORTz_barry_test.
PARAMETERS: P_INPUT(10) TYPE C LOWER CASE.
IF P_INPUT CP '#S#A#P123'.
WRITE:/ 'YES'.
ELSE.
WRITE:/ 'NO'.
ENDIF.

OR:

REPORTz_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
页: [1]
查看完整版本: SAP中的通配符和转义符