| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 CSV to Table | Other | Advanced /
Bradley Morris | 6009 since
6/13/2001 2:42:17 AM |
By 1 Users
|
| |
This MS SQL 2000 function takes a string of text and returns a table. Sort of like the Split function in VB. |
| |
| |
| |
|
dbo.DoubleMetaPhone | SQL Server 7.0, Other | Intermediate /
Keith Henry | 25826 since
8/5/2002 1:32:47 PM |
By 4 Users
4 Excellent Ratings
|
| |
Creates a better phonetic matching key than Soundex. |
| |
| |
| |
|
 delimited strings / lists | SQL Server 2000 | Beginner /
Charles Toepfer | 4585 since
3/16/2004 5:43:59 PM | Unrated
|
| |
Deal with delimited strings |
| |
| |
| |
|
Evaluate the value of an expression in a string.sql | SQL Server 7.0 | Beginner /
Umachandar | 4274 since
7/18/2000 8:41:10 AM | Unrated
|
| |
How to evalulate an expression in a string & get the value |
| |
| |
| |
|
Explode | SQL Server 2000 | Intermediate /
Gilbert Abellar | 4460 since
6/25/2008 1:26:25 PM | Unrated
|
| |
Retrieve Exploded string. |
| |
| |
| |
 |
 Find Longest Or Shortest Length | Oracle | Advanced /
Andy Archer | 4997 since
1/30/2012 11:58:00 AM | Unrated
|
| |
This PL/SQL stored function returns the length of the longest or shortest in_delim-delimited character or string in in_string. With SQL*Plus test script. |
| |
| |
| |
|
fn_ReplaceVariables | SQL Server 2000 | Advanced /
John C Kirwin | 3759 since
12/7/2005 11:31:10 PM | Unrated
|
| |
User Defined Function to replace parameter place holders in a string |
| |
| |
| |
|
fnSplitLines table UDF | SQL Server 2000 | Advanced /
Veber | 4083 since
3/17/2004 2:29:33 AM | Unrated
|
| |
This function is greatly useful when you want to transfer some "array" of values to stored procedure as string parameter. Conventional T-SQL solutions like temporary tables and cursors are unaccessable when calling stored procedure from client program. Ad ...(description truncated) |
| |
| |
| |
|
fnStripChars | SQL Server 2000 | Beginner /
Shane Lively | 3589 since
8/26/2002 1:44:57 PM | Unrated
|
| |
Strips unwanted characters from an alphanumeric value. Useful for data cleanup. |
| |
| |
| |
|
 FormatDate | SQL Server 7.0 | Intermediate /
Lewis E. Moten III | 49844 since
5/22/2002 4:35:10 PM |
By 9 Users
8 Excellent Ratings
|
| |
Dynamically convert a date to a user-defined format. (ScreenShot) |
| |
(ScreenShot)
