_123 TSQL functions updated 09-08-2002

_123 TSQL functions


"This is a collection of 123 TSQL functions for professional, academic or learning purposes. There are many conversions hexadecimal/octal/binary/Roman numerals, mathematical functions such as hyperbolic, logic and trigonometric. Combinatorial functions such as combinations, permutations (factorial), arrangements. Other interesting functions include turning a number into plain English, Morse code, EBCDIC and vice-versa, Levenshtein Distance (linguistics), encryption, infinite precision division and number theory functions: primes, deficient, perfect, abundant, golden numbers. Validation: valid email, IP, ZIP code and many others. There are some useful string functions to count occurrences of a string within another, find a character position in a string from the end of the string, wrap, rewrap, unwrap a string, etc… Some functions are clones from Microsoft Access or VBA(IIF, date, time, IsNull, IsEmpty), others from Oracle (INITCAP, TRANSLATE, RPAD, LPAD, ADD_MONTHS, MONTHS_BETWEEN, LAST_DAY, NEXT_DAY). Base convertion(10)+Combinatorial(6)+Algebra(9)+Numeric(14)+String(24)+Date(8) Comparison, validation(27)+Logic(11)+Trigonometric(5)+Hyperbolic(9)=123 total Levenshtein Distance algorithm-original developer: Michael Gilleland (thank you for allowing me to translate the code to TSQL J ) http://www.merriampark.com/ld.htm Tested on Microsoft SQL Server 2000, BigInt should be replaced with int, in order to work with other versions of Microsoft SQL Server or Sybase. ..."

Very cool collection of SQL functions...