One field that I need to display in a report has the potential of being kind of long (over 100 characters). I'm using SQL Server 2008, and in this case, I'm using a table for the display. Most users will want to export the report to Excel.
I'd like to display only the first few characters of that one field, but I don't want to truncate it in my SQL query. I want users to be able to see the entire contents if they choose to. I have Googled this and have had no luck. I have a hard time thinking I'm the first person to ask this.