| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Isolate last word in field | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Dave B Bell | 3997 since
2/12/2004 6:01:45 AM | Unrated
|
| |
The company I work for has a billing system that holds all the customers name details in one field - often the surname is needed alone - this code quickly isolates the surname |
| |
| |
| |
 |
 Just The Alphas & Just The Digits | Oracle | Beginner /
Andy Archer | 9814 since
1/27/2012 11:24:34 AM |
By 3 Users
3 Excellent Ratings
|
| |
Just_the_alphas is a tiny PL/SQL stored function returning in_string's alphabetic characters as a varchar2 concatenation. Similarly, just_the_digits returns the digits (0123456789). With SQL*Plus test scripts. |
| |
| |
| |
|
 LastIndexOf | SQL Server 2000 | Intermediate /
Gilbert Abellar | 9145 since
6/25/2008 1:26:38 PM | Unrated
|
| |
For string slicing purposes. |
| |
| |
| |
|
Led Display | Other | Intermediate /
Alejandro Escobedo Lozoya | 3247 since
3/1/2006 12:22:03 AM | Unrated
|
| |
Draws a LED Display |
| |
| |
| |
|
Metaphone | SQL Server 7.0 | Intermediate /
Keith Henry | 4896 since
8/6/2002 4:55:11 AM | Unrated
|
| |
Less powerful algorithm than Double Metaphone posted by myself earlier, but still better than soundex |
| |
| |
| |
|
Newbie Line Seperators | SQL Server 6.5 and earlier | Beginner /
Lewis E. Moten III | 5327 since
4/1/2002 2:52:30 PM |
By 3 Users
|
| |
Simple way to insert a carriage return + line feed into a string. Really beginner stuff ... I keep forgetting sometimes. Rather spend time looking it up in the docs or old code, I'm putting it here to access it quicker. Hopefully someone else may also fin ...(description truncated) |
| |
| |
| |
|
Parse File Extensions | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Lewis E. Moten III | 3829 since
7/27/2004 8:07:24 PM | Unrated
|
| |
Parse file extensions with SQL |
| |
| |
| |
|
Pass 1-unlimited values to a stored procedure | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
moppy | 3418 since
6/7/2004 9:42:06 AM |
By 1 Users
|
| |
Allows the user to pass as many values as needed into a SQL stored procedure |
| |
| |
| |
|
Pattern Matching - Part 1 | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
David Drake | 5046 since
5/1/2002 7:44:40 PM |
By 6 Users
|
| |
--
-- This tutorial will teach you
-- how to use Pattern Matching
-- to strip leading zeros off
-- of String data.
-- |
| |
| |
| |
|
PostodeValid | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Keith Henry | 3066 since
8/27/2002 7:48:21 AM | Unrated
|
| |
Validates UK Postcodes against Royal Mail Offical Spec |
| |
