XLeratorDB/strings adds many new tools (that are precisely matched to Excel) to the 23 native functions built into SQL Server. Plus, there are dozens of new functions for the kind of demanding database operations that are simply beyond the scope/scale of a spreadsheet application.
Now you can use easy and familiar text handling funtions similar to those found both in Excel and the Microsoft .NET framework directly in your T-SQL. XLeratorDB strings offers powerful and fast text manipulation functions - PARSE specific elements out of text strings, CONCATenate many rows of text data into a single line, SPLIT data by delimiters into rows quickly and efficiently.
XLeratorDB/strings also offers a rich set of formatting functions that are much more flexible and easier to use than the built in SQL Server functions. Format numbers, dates, times, currencies, etc. with easy and familiar patterns such as 'mm/dd/yyyy' and '###,###.00' instead of memorizing cryptic numeric codes.
On top of this, there are also functions for inspecting text strings, such as ISNUMERIC, NUMWORDS, STARTSWITH, CONTAINSSTR and more - PLUS - calendar functions for calculating working days.
XLeratorDB gives you the familiarity and flexibility of Excel with the power and reliability of in-database analytics – without the headaches of cut-and-paste errors. And in many instances eliminating exports and imports to Excel can mean up to a 99% reduction in processing times as well.