register
login
shopping cart
0 items in cart
Tweet
function libraries, tools and services for Microsoft SQL Server
Contact Us
Support
NoSQL vs SQL
Purchase
Download
Products
Home
SQLUtilities
SQLFinancials
SQLStatistics
SQLRollingStats
SQLMath
SQLEngineering
SQLDistributions
SQLFile
SQLTuples
Assembly Manager
Bespoke Assemblies
Data Migration
Data Cleansing
Database Design
Business Intelligence
Application Design
Features
Overview
Pricing
Documentation
SQLUtilities
Powerful functions for string, date
& time manipulation & more...
Edit
Number sequence generator - returns an instant table of numbers of any length, start point & interval.
Date / time sequence generator - returns an instant table of dates/times of any length, start point & interval.
Random integer & float number generators that return new random values for each row in a query.
Random date, time & date/time generators for selecting a date/time at random between two bounds.
Working day calculations: count working days, nth working day etc. Adjustable weekends & holidays.
Relative date functions: start of month, end of month, n
th
Wednesday in the month and so forth.
Advanced date & time conversion, formatting, manipulation & arithmetic.
Parsing and formatting of numeric, currency & date/time string values using custom formats.
Split delimited strings into rows, aggregate rows into delimited string, retrieve n
th
substring etc.
Text processing: pattern matching, substitution, searching, cleaning, formatting, comparison.
Full regular expression text processing (matching & substitution).
Relative column lookups (e.g. get value of column A at max value of column B).
Request Callback
Buy Online
Download Trial
Talk to Us
Next Steps:
My Account
Privacy Policy
Terms of Use
Partners