SMS Text Message Data Unreadable

Our company sends out sms text mesgs from our MSSQL Database and stores the responses in a table when a reply is received. My problem is now that some mesgs are showing as blank(even when I copy the raw data field out of the query return window) yet when I check the length of the field, it contains data. I set the field to a Temp Variable and converted the contents to ascii and definitely found that it shows data.

We use this reply as a rating system and I have queries and functions that extract the info I need, the problem is that I need to convert this field into a readable field first before I can extract the info.

SQL example:

Select T2.ReceivedData , Datalength(T2.ReceivedData) Length
FROM DMZWEB01.[SMS_SERVICE].[dbo].[Sent] T1
LEFT JOIN DMZWEB01.[SMS_SERVICE].[dbo].[Reply] T2 ON T1.ID = T2.ID
INNER JOIN Clm_ClaimsRegister T3 ON T1.PolicyNumber = T3.Claim_No
Where T1.id = 1158008

This returns a blank field and a datalength of 6.

To prove that the field contains data, a query that can run is:

DECLARE @Temp VarChar(8) =
(Select T2.ReceivedData
FROM DMZWEB01.[SMS_SERVICE].[dbo].[Sent] T1
LEFT JOIN DMZWEB01.[SMS_SERVICE].[dbo].[Reply] T2 ON T1.ID = T2.ID
INNER JOIN Clm_ClaimsRegister T3 ON T1.PolicyNumber = T3.Claim_No
Where T1.id = 1158008

[Code] ...

This returns < Line numbers >

1>
2>1
3>
4>0
5>&
6>:
7>

the actual field is pasted between these two comment '' signs below
''
see? nothing