Always remain updated about current software development trends
LTRIM and RTRIM don't always remove all the whitespace characters in a field such as carriage return or linefeed
In SQL Server 2008, I do that with a CLR User Defined Function:namespace PIEBALD.Lib{ public static partial class LibSql { public static string Trim ( string Victim ) { return ( Victim.Trim() ) ; } }}Needs to be built into a...
c# .net dev intermediate asp.net windows sql beginner silverlight advanced c++ architect javascript sql server wpf mysql html5 mobile c#4.0 jquery