The following sql query worked fine in interbase 6.02 but not in
firebird. Can
anybody please help explain why? The error is token unknown "and".

select
t.TEAMNO,
t.TEAMNAME,
t.activestatus,
t.Leagueno,
l.LeagueName from
TEAMS t
join Leagues l on l.leagueno = t.leagueno
join Sports s on s.sportno = l.sportno
where s.CID = :pCid
and t.UPPERTEAMNAME starting with upper(:pAlpha)
order by t.upperteamname