Get Left String in query.

[Former Member]

Hi ,

I need to check the first char of a table field in a query.

i now that on global filed i can do like this:

IF name(1) = '7'.
  do something.
ENDIF.

How can i do that here :

 SELECT  carrid connid fldate seatsocc seatsmax
    FROM sflight
                INTO CORRESPONDING FIELDS OF wa_flight
                WHERE left (carrid,1) = '7'

Thanks.

[Former Member]

You cant. You need to read the table field into a working field then check it there.

You cannot use offset values for select statements.

[dhruv_shah3]

Hi,

If your requirement is just fetching the records which starts from 7 then you can use the Like clause in the select query.

HTH

Regards,

Dhruv Shah