>Someone in the office figured out that CAST() works...
>

of course. CAST declare that you accept the loss of extra characters.

>http://msdn2.microsoft.com/en-us/library/ms187928.aspx
>
>

>>Well, Chad that works great! However, I just checked the second table and it is text not char so it doesn't work on that. What would work with a text field type in sql server?
>>
>>
>>
>>
>>
>>>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'