Regex in where

Code: Alles auswählen.

...
    replace( z.ktext, ' ' ,`` ) as ktext_condensed,   
...

Code: Alles auswählen.

types:
  begin of lty_row,
    spras   like t005t-spras,
    landx50 like t005t-landx50,
  end of lty_row.

data:
  lt_table type standard table of lty_row with default key,
  ls_row   type lty_row.

exec sql performing adopt_entry.
  select spras, landx50
    into :ls_row-spras,
         :ls_row-landx50
    from t005t
   where mandt   = :sy-mandt
     and landx50 = 'Costa Rica'
endexec.

break-point. " check lt_t005t

form adopt_entry.
  replace all occurrences of ` ` in ls_row-landx50 with space.
  append ls_row to lt_table.
endform.

Code: Alles auswählen.

types:
  begin of lty_row,
    spras   like t005t-spras,
    landx50 like t005t-landx50,
  end of lty_row.

data lt_table type standard table of lty_row with default key.

select  spras, landx50
  into  @data(ls_row)
  from  t005t
  where landx50 = 'Costa Rica'.
  replace all occurrences of ` ` in ls_row-landx50 with space.
  append ls_row to lt_table.
endselect.

Code: Alles auswählen.

select  spras, landx50
  into  @data(ls_row)
  from  t005t.
  replace all occurrences of ` ` in ls_row-landx50 with space.
  if ls_row-landx50 = |CostaRica|. " where condition
    append ls_row to lt_table.
  endif.
endselect.