SQL SERVER TRIM Function to Remove Leading and Trailing Spaces of String SQL in Sixty Seconds #040 Video

Posted by: Journey to SQL Authority with Pinal Dave, on 23 Jan 2013 | View original | Bookmarked: 0 time(s)

Trim is one of the most frequently used operation over String data types. A developer often come across a scenario where they have the string with leading and trailing spaces around string. If your business logic suggests that the logs around the spaces are not useful they should be trimmed. However, in SQL Server there [...]...

Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 241 | Hits: 7

Similar Posts

  • LINQ Tip of the week: System.String support more
  • Handling "GO" Separators in SQL Scripts - the easy way more
  • Getting SQL Server registry settings via SQLCLR table-valued user-defined function... more
  • Getting GrandParent columns with ADO.NET more
  • Bulkload Sample Code more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD