CODEWITHSUNDEEP
sql-server-2012varcharmax
user3587785
user3587785

Reputation: 3

sql server select only part of string column in result set

I have table T with column A as Varchar(max) when I select this field in result pan it only show part of data of this column(only 1457 character) but len(A) return 1730 character. when I select A the result end with this string:

DSL-combined-Line-Info:

but when I select right(A) it give me another string.

select
    packet,
    len(packet) as lenght
FROM  [CDR]
where stopTime='2013-05-01 00:00:00.123' and LoginName=2612536328

the packetcolumn in the result pane give me only 1457 character but len(packet) give me 1730 in the result

Upvotes: 0

Views: 218

Answers (0)

Related Questions