Definite 255 char limit. See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65584

I used the function to get around and loop through

declare @Apptemp3 table (BSamName varchar(255),

BDisplayName varchar(255),

BPhone varchar(100),

BEMail varchar(255),

BFirstName varchar(100),

BLastName varchar(100))

DECLARE @sChar char(1)

declare @body varchar(8000)

DECLARE @nAsciiValue smallint

SELECT...

I found that to be true as well, think it is something to do with the string length, used * to just pull all the columns and save on the...