Re: Center Align Integer Returned From Select Statement

[Peter Brawley]

That's usually done in the app language. In mysql it'll be awkward, eg ...

set @n=100;
set @pad = floor( (7-length(@n))/2 );
select concat( repeat(' ', @pad), @n, repeat(' ', @pad) ) as res;