Page Comparison

SELECT
 l.loanID loaninID,
 l.loanNumber loanInNumber,
 (CASE WHEN l.loanPurposeID != 0 THEN 'urn:cspace:pahma.cspace.berkeley.edu:vocabularies:name(loanpurpose):item:name(' + lower(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(p.loanPurpose, ' ', '_'), '-', '_'), ':', ''), '.', ''), ',', '')) + ')''' + p.loanPurpose + '''' END) loanPurpose,
 (CASE WHEN l.constituentID != -1 THEN l.constituentID END) borrowerlender, --?
 l.beginISODate loanInDate,
 l.endISODate loanReturnDate,
 (CASE WHEN l.requestDate IS NOT NULL OR l.requestedBy IS NOT NULL THEN 'urn:cspace:pahma.cspace.berkeley.edu:vocabularies:name(loanstatus):item:name(requested)''requested''' END) loanStatus,
 CONVERT(VARCHAR, l.requestDate, 101) loanStatusDate,
 (CASE WHEN l.requestedBy IS NOT NULL THEN 'Requested by: ' + l.requestedBy END) loanStatusNote,
 l.description loanInNote_1,
 (CASE WHEN l.contact IS NOT NULL THEN 'Contact: "' + l.contact + '"' END) loanInNote_2,
 l.remarks loanInNote_3
FROM
 Loans l
 JOIN LoanPurposes p ON l.loanPurposeID = p.loanPurposeID
WHERE
 l.loanin = 1
 ;