Tracy,
Just RTRIM() the name inside the ISNULL().
HTH,
Chad
>update tbl_main set name = isnull(name,'') +' MORE STUFF TO ADD TO NAME FIELD' where my_id = '01-011'
>
>
>Why not? It returns string or binary data would be truncated.
>
>Cannot do this either because it is a char:
>
>update tbl_main set name .write (N' MORE STUFF',NULL,0) where my_id = '01-011'
_________________________________
There are 2 types of people in the world: