You are amazing :-)!!!!!!!!!!!!!!!!!!!!! Thanks!

I can't believe the error I had. My @SEQ was only varchar(100) and so it was getting cut off after the word description in my...

Here are the declerations that i use...

*********************************

IF EXISTS (SELECT ID FROM TEMPDB.DBO.SYSOBJECTS WHERE ID = OBJECT_ID('TEMPDB.DBO.#TABLE_DATA'))

DROP TABLE #TABLE_DATA

CREATE TABLE #TABLE_DATA (

FIELD_DATA varchar(1000) )

DECLARE @SEQ VARCHAR(100)