EASY! Trim string?

I have values in a matrix takin too much space. Since they are just used as the matrix column header, cant i trim it or something. To display just the first 3 letters of the the attribute, and not the whole string? Whats the code for that?

=Fields!Collision_Type.Value thats my field right now.

Please help! thanks!

=LEFT(Fields!Collision_Type.Value,1,3) I believe. Or some variant of that syntax.|||

I believe it should be Mid(Fields!Collision_Type.Value,1,3)

|||

Yes, you can change it to this to always show the first 3 characters:

=Left(Fields!Collision_Type.Value, 3)

Jarret

|||Thanks for the quick response, this worked great!|||This one worked as well, hum i wonder what the difference is? But they both seem to display the same. Thanks!|||

There is no difference really, the Mid function allows you to give it a starting position and how many characters to return.

Jarret

Easy Determine Free Disk Space Another Disk Drive

What is easy way to return a value for the free disk space on another server
?
Please help me with this problem.
Thank You,Why would you want SQL Server to do this? I would use VBScript's
FileSystemObject or WMI and populate SQL Server with the information, maybe
on five minute intervals. When you run the query from SQL Server, the data
is up to five minutes old, but the user doesn't wait and there are no file
share / server access permissions issues.
A
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:4DB5CF71-938E-4E43-ACE2-73392DB4590B@.microsoft.com...
> What is easy way to return a value for the free disk space on another
> server?
> Please help me with this problem.
> Thank You,
>
>
>sql