Right Justify data in a column

[Idokyoku2]

Hello,
I need help flushing data to the right of a column Char(100). I've tried something like this:

update tbl02
set BusAddr = ' '+RTRIM(BusAddr);

Data does move to the right some, but I receive a termination error, since some data would be truncated.
This is problematic since length of data varies.

Anyone have a better statement/idea?
David

 

[vongrunt]

1. Don't use char(100), prefer varchar(100)

2. Try not to format data in DB table. Store strings naturally left-aligned, format results either at runtime or outside database.

3. To right-align data at runtime, try RIGHT(REPLICATE(' ', 100)+RTRIM(BusAddr), 100)

 

[Idokyoku2]

Right on! That worked perfert!

You're my new best friend!

Thanks a ton.
David