How can I RIght Justifiy a field

[isonlyme]

Hi

I have a table with a field char (10)

the records on that field some have 3 spaces on the left and the rest doesnt have spaces on the left example:

the line underscore (___) means space in the left for demostration purpose

"__MYDATA"
"MYDTA__"

I want all the data to be like this "__MYDATA"

Im doing this: upadte tablebame set myfield = rtrim(myfield)

but it doesnt change anything

Any suggestions please this is rush

THANKS!!

 

[SQLDenis]

update tablebame set myfield = ' ' + rtrim(myfield)
where len(rtrim(myfield)) = 7



Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[isonlyme]

Thank you very much!

 

[bborissov]

UPDATE MyTable SET MyField = RIGHT(SPACE(10)+LTRIM(RTRIM(MyField)),10)

Borislav Borissov

 

[MDXer]

Be sure to note somewhere that you did this and why. THis type of stuff has a way of causing developers grief down the road when they are querying for something and 'MYDATA' returns 0 rows because of padding.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck