Truncate/Trim SQL Statement?

Truncate/Trim SQL Statement?

Page 1 of 1

0 Replies - 577 Views - Last Post: 01 March 2010 - 09:36 AM Rate Topic: ***** 1 Votes

#1 Guest_Knockkneed81*


Reputation:

Truncate/Trim SQL Statement?

Posted 01 March 2010 - 09:36 AM

I use the following statement for a report, but the report is running into issues when tryin to export it to excel. Some of the records fields are too long for Excel's cells, so the report bombs. How can I fix this issue without deleting or modifying any data in SQL? I believe there is a way to truncate table information that is pulled from SQL, so it will open in Excel (32k). What is the correct SQL statement to use to accomplish this? Any ideas is greatly appreciated.

Select CallLog.CallID, CallLog.CustID, CallLog.CallType, CallLog.CallStatus,
  CallLog.Priority, CallLog.ClosedDate, CallLog.RecvdDate, CallLog.CallDesc,
  Journal.EntryText 
From CallLog Inner Join
  Journal On CallLog.CallID = Journal.CallID
where CallLog.CallStatus != 'Closed'


Is This A Good Question/Topic? 1

Page 1 of 1