topic Re: Get Left String in query. in Application Development and Automation Discussions

Get Left String in query.

Former Member — Wed, 26 Mar 2008 09:41:45 GMT

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.

Re: Get Left String in query.

Former Member — Wed, 26 Mar 2008 09:45:30 GMT

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.

Re: Get Left String in query.

dhruv_shah3 — Wed, 26 Mar 2008 09:49:10 GMT

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