Is there a way that I can reduce the length of a string? I am getting a rather large text string (from SQL Server) into a label, but I only want first 50 characters to show with "..." following those 50 chars initially. e.g. "This is the string..." How can I do it?


What we do with information is... ART!

Do you want to do this with SQL of your consumer? You haven't specified what is using the data from sql so we can't really suggest anything specific without knowing what language/technology you are using. But typically there is a function which will get you a part of a string: Left() or SubString() or SubStr() or something like that. You provide it with a source string, a count of characters and a start position. Then just concatenate your "..." to the end.

Peter
------------------------------------------------------
Work smarter, not harder.