Skip to Content
0
Former Member
Jan 20, 2011 at 10:35 AM

Q32: Defining column width

45 Views

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