why does 'r ' = 'R'

this is like saying Length or 2 = Length of 1

in the problem it is small r + a blank space set = capitol...

why does 'r ' = 'R'

this is like saying Length or 2 = Length of 1

in the problem it is small r + a blank space set = capitol...

select * from

(

SELECT c.CATEGORY_NAME, YEAR(a.INSTALLATION_DATE) AS [Year of Construction],

a.REPLACEMENT_VALUE AS [Replacement Cost]

FROM dbo.AMS_ASSETREGISTER a INNER JOIN

dbo.AMS_CATEGORY c ON a.CATEGORY_ID = c.CATEGORY_ID INNER JOIN

dbo.AMS_FIN_LINK f ON a.ASSET_SYS = f.asset_sys

) as...