Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

what does like '2003%" mean

Hi can any one explain the behaviour of like statement below and tell me what exactly it does,what does % mean here..

SELECT * FROM SFLIGHT

INTO XFLIGHT

WHERE CARRID = 'LH'

AND CONID = '0300'

AND FLDATE LIKE '2003%'.

ENDSELECT.

Tags:
Former Member
replied

it will select all the data which has the date starting with 2003... means all data for year 2003.

Regards,

Naimesh Patel

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question