Hi AndyFel,

 

Thanks much, for taking the time.

- The query results in default sql server grid don't show the boxes (as you suggested wouldn't happen), but there are spaces in between. 

so it looks like:  asd<br />  asd<br />  asd<br />  <br />

 

- The query resutls to text look like the following:

 

 

 

 

- If I remove the CR and LF boxes manually by editting the table in Ent. Manager (man. studio) the text displays perfectly when I query from sql server (no spaces) and as well in the flash application that is grabbing data from the database.

 

- I switched the column datatype to nvarchar as suggested - but no change for me here.

 

- Any info on how to remove the CR and LF boxes? or possibly any other ideas?

 

Thanks again to Adam and AndyFel for there continued help, 

 

Rob