| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Parse Phone Info | SQL Server 2000 | Intermediate /
Sean P. O. MacCath-Moran | 4579 since
5/9/2003 9:42:39 AM |
By 1 Users
|
| |
This function will parse a text string containing phone number data with an unspecified format and returns specified pieces of the phone number in with a specified format. Please vote and / or comment! =o) |
| |
| |
| |
|
 Proper | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Rob Waibel | 4500 since
6/9/2004 2:12:26 PM | Unrated
|
| |
I work with Lead contacts all day and users who either leave the caps lock on OR type in all lower case. I find this type of data ugly, so...
I created a Procedure I can Callduring my import process that will property capitalize Last names, First names an ...(description truncated) |
| |
| |
| |
|
 Remove Carriage Returns and Line Feeds | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle | Beginner /
Mike J Anderson | 6037 since
8/31/2001 4:20:06 PM |
By 3 Users
2 Excellent Ratings
|
| |
This code will help you remove carriage returns and line feeds from you Oracle .db. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Select Distinct Text Fields | SQL Server 2000, SQL Server 7.0 | Intermediate /
Ysaias Portes | 7087 since
3/29/2005 3:21:20 PM |
By 1 Users
|
| |
Convert string to Numeric and select distinct rows. It works perfect when working on tables without unique ID. This code will allow you to select tree fields and convert them to a unique number. You must change the STRING_COLUMN1,STRING_COLUMN2,STRING_COL ...(description truncated) (ScreenShot) |
| |
| |
| |
|
sp_fileop.sql | SQL Server 7.0 | Advanced /
Umachandar | 6221 since
7/23/2000 2:17:32 PM |
By 1 Users
|
| |
How to create files, write to files, delete files from T-SQL using DOS commands? |
| |
| |
| |
|
Spell Number | Oracle, Other | Intermediate /
Naif Salim Al Hamed | 4625 since
7/21/2002 3:17:47 AM |
By 2 Users
2 Excellent Ratings
|
| |
Spell,Write,Convert digital number to text word number for more than one language(English /Arabic ..). Easy way just use function to do it from 123456789123456789 and more, The Default Currency is my (Riyal you can chaing to Doller) and 1/100 Currency( Ka ...(description truncated) |
| |
| |
| |
|
SQL Server data encrypt function | SQL Server 2000 | Beginner /
Mikhail Shmukler | 7191 since
3/12/2003 9:55:01 AM |
By 1 Users
|
| |
This function demonstrates how to encrypt / decrypt sensible data in your MSSQL Server database |
| |
| |
| |
|
String to Value | SQL Server 2000 | Advanced /
Jeff Michelson | 4549 since
11/4/2004 12:12:11 PM |
By 2 Users
|
| |
This function will convert a string value to a numeric, stripping out non-numeric character values, taking an accounting-type negative (perenthasis or right aligned negative sign), and returning a decimal. |
| |
| |
| |
|
Strip Text Fields | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 4631 since
7/27/2000 9:09:42 PM | Unrated
|
| |
How to strip a text field into several varchar fields. |
| |
| |
| |
|
Sub Select Example | Oracle, Other | Intermediate /
Mike J Anderson | 9614 since
1/9/2002 8:09:01 PM |
By 1 Users
|
| |
Code uses a subselect to select data from Table1 (Constituent) where the primary key matches Table2's (TEMP) primary key then updates a target field (c.CUSTOM_BOOLEAN1) based on the match. |
| |
(ScreenShot)
