[RESOLVED] Filtering data

[dcjones]

Hi all,

I have a query and need the result to extract the data where the filter "AND AirlineTeleLhr.Code = LHRFlightStats.AirlineCode
" brings back the first two characters of "LHRFlightStats.AirlineCode
". Can this be done?

The complete query

SELECT DISTINCT
LHRFlightStats.Flight,
LHRFlightStats.ScheduledTime,
LHRFlightStats.Terminal,
LHRFlightStats.Logo,
LHRFlightStats.IATALookup,
LHRFlightStats.RemarksWithTime, 
LHRFlightStats.AirlineCode,
AirlineTeleLhr.Code,
AirlineTeleLhr.Telephone
FROM
LHRFlightStats
Inner Join AirlineTeleLhr ON LHRFlightStats.AirlineCode = AirlineTeleLhr.Code
WHERE  LHRFlightStats.ArriveDepart = 'I'
AND LHRFlightStats.FlightDisplay = 'Y'
AND AirlineTeleLhr.Code = LHRFlightStats.AirlineCode ORDER BY
LHRFlightStats.ScheduledTime ASC

[Lars_Berg]

AND AirlineTeleLhr.Code = substring(LHRFlightStats.AirlineCode,1,2)

The name and syntax for the substring function may vary among different DBMS.

[dcjones]

Hi Lars Berg,

Many thanks for your reply.

Works a treat, thank you.