SQL Server Script: Find CR by CR Number

Select cr.ChangeNumber AS [CR Number], cr.Synopsis AS [Synopsis], p.Name AS [Project Name], v.name AS [view], cr.DotNotation
FROM syn_change cr, syn_project p, syn_view v
WHERE cr.ViewID = v.ID AND
v.ProjectID = p.ID AND
cr.ChangeNumber = '80' -- Edit this line to change the CR Number searched for