The t0.free_text column is massively wide - can I define the column width at all?
SELECT t0.cardname as 'Customer Name', t0.cardcode as 'Customer Code', t1.name as 'County', t2.slpname as 'Owned By', t0.frozenfor as 'On Hold', t0.notes as 'Notes', t0.free_text as 'Remarks'
FROM ocrd t0 inner join ocst t1 on t1.code = t0.state1 and t1.country = t0.country inner join oslp t2 on t2.slpcode = t0.slpcode
WHERE t0.cardtype = 'C'
ORDER BY t2.slpname, t0.cardname
Thanks,
Robin