I completely missed what was happening here.   

You need to search this site for parsing your text data into a temp table.  This...

Well worth it!  I had completely fogotten about that one. 

My apologies!  I think we may all be esurient!   

You need to specify the field(s) you are updating. 

UPDATE TableName SET

     ColumnName = mi_master.ColumnName

-- you may need to join the tables here, (i.e., TableName and mi_master)

WHERE [number]...

If you require a specified number of characters, use char.  Otherwise, varchar allows for more flexibility.  I have often had jobs where "this will NEVER change!"  And then, six months...

Off?  I guess now it may as well be SCC dumbhead.   

YES!  Did you post an actual picture? 'cause I missed that one. 

(You may want to consult Remi, Noel, Steve, etc. for your moniker thinking cap - although I may...

esurient \ih-SUR-ee-uhnt; -ZUR-\, adjective:

Hungry; voracious; greedy.

(okay sushila - while this may fit the picture you posted, I do not believe it fits you...  am I wrong...

"Cursorless"?  To cursor, or not to cursor.  That IS the question? 

David's explanation of the need for RTRIM( LTRIM( )) is absolutely correct. 

The reason I suggested a new column is, if anything goes wrong, you have the potential to loss...

"esurient"?!  I think that one belongs in the irony thread.  sushila is many things, but esurient is definately not one of them. 

Now, there may be some others, (Canadians not...

ALTER TABLE TableName ADD NewColumnName varchar(4) NULL -- I am assuming the OriginalColumnName can contain NULLs. 

GO

UPDATE TableName SET

          NewColumnName = RTRIM( LTRIM( OriginalColumnName))

ALTER TABLE TableName DROP...

Gawd she's a tough cookie.  Sometimes latin, sometimes french..., but she sure won't let the Inglish be spelt rong...  

I figured Remi's was just simply looser as he can type faster...

Now there's a picture.  A "committed" person "christening" themselves...  Are you able to pop the champagne bottle with the nice tight white jacket wrapped around you? 

You lost me.  I think you posted only a portion of the text within your [Description] column.  This lead Ian, (good addition to my code) and I to believe you...