| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 function Split | SQL Server 2000, SQL Server 7.0 | Advanced /
Sergio Cardoso | 8268 since
12/24/2002 6:46:13 AM |
By 5 Users
3 Excellent Ratings
|
| |
This function does the same as the function SPLIT in Visual Basic. |
| |
| |
| |
|
Function That will work as initcap function of Oracle | SQL Server 7.0 | Beginner /
Hemant Kailashchand Garg | 3399 since
5/20/2002 12:33:23 AM | Unrated
|
| |
This Function will convert the first alphabet of each word of passed string to capital. e.g. the string 'heMant KaIlashchand garG' will be returned as 'Hemant Kailashchand Garg'. |
| |
| |
| |
|
 Generate a random n-character string | SQL Server 7.0 | Intermediate /
mjburian | 6746 since
10/25/2001 4:29:19 PM |
By 6 Users
2 Excellent Ratings
|
| |
Generates a random n-character string using only 0-9 and A-Z. Just change the value of @NumberOfChars to get different lengths. Might be useful to generate passwords or acceptance codes. Sorry about lack of comments, but I couldn't get the formatting righ ...(description truncated) |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
 |
 generate a SOUNDEX equivalent for a last name (two methods) | Oracle | Advanced /
Andy Archer | 5656 since
10/6/2009 9:05:35 AM |
By 2 Users
|
| |
Here are two SOUNDEX algorithms, as PL/SQL stored functions. Each proc returns a code for the input last name, which can be indexed and queried. |
| |
| |
| |
|
Get Ascii Conversion Table | SQL Server 7.0 | Intermediate /
Dumitru Radu | 3714 since
10/18/2001 3:22:45 PM | Unrated
|
| |
Get the ASCII conversion table |
| |
| |
| |
|
Get Davidson String from String | SQL Server 2000 | Beginner /
Marcel Berger | 3008 since
11/1/2004 7:01:26 AM | Unrated
|
| |
manipulate a string to a Davidsonstring |
| |
| |
| |
|
Get octets from an IP Address | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Beginner /
Umachandar | 3558 since
7/25/2000 8:39:44 PM | Unrated
|
| |
How to retrieve individual octets from an IP address. |
| |
| |
| |
|
Get String Fragment (can be called repeatedly to split a string into pieces) | Oracle | Advanced /
Andy Archer | 9677 since
7/13/2009 8:45:16 AM |
By 2 Users
2 Excellent Ratings
|
| |
Using the SUBSTR and INSTR built-ins, this PL/SQL stored function searches the IN string in either direction to find and return the parameter-defined piece. No loop. Clean and quick. With SQL*Plus test script. (ScreenShot) |
| |
| |
| |
|
GetVBCRLF | SQL Server 2000 | Advanced /
Brad G Skidmore | 4261 since
4/8/2004 8:25:56 PM | Unrated
|
| |
Constant for Carriage-return/Linefeed combination; equivalent of Chr$(13)+Chr$(10) |
| |
| |
| |
|
Global replace | SQL Server 2000, SQL Server 7.0 | Intermediate /
Marcelo Girao Silva | 5170 since
7/14/2004 6:05:38 PM |
By 1 Users
|
| |
This procedure can be used to to perform a text replace in all tables in the database in a single command.
It will search all the string columns in the database, except for system objects, and replace the text you define. |
| |
(ScreenShot)
