Select partial field

[Former Member]

Hi,

Please let me know if there is a better way to select the record based on this criterial. I need to select records from a table but the first 2 position of that fiel is of certain value. For example,

SELECT DOCNR RFUND into table i_tab from FMGLFLEXA

where the first 2 positions of field RFUND = 'F1'.

Field RFUND is 10 char. I tried various scenarios to extract the record in the select statement but nothing work. Any idea?

[Former Member]

Hi,

Please let me know if there is a better way to select the record based on this criterial. I need to select records from a table but the first 2 position of that fiel is of certain value. For example,

SELECT DOCNR RFUND into table i_tab from FMGLFLEXA

where the first 2 positions of field RFUND = 'F1'.

Field RFUND is 10 char. I tried various scenarios to extract the record in the select statement but nothing work. Any idea?

[Former Member]

Moderator message - Please do not ask basic questions. Press F1 on SELECT WHERE - post locked

Rob