| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Convert money value to the word value. | SQL Server 7.0, Other | Advanced /
James Travis | 12173 since
4/12/2002 1:04:34 PM |
By 3 Users
|
| |
With this script you can supply an money value such as $12525.83 and it will return the word value "Twelve Thousand Five Hundred And Twenty-Five Dollars And Eighty-Three Cents".
It is comprised of a table for Number to Name and a procedure to parse into i ...(description truncated) |
| |
| |
| |
|
Convert Number to Text | SQL Server 2000, SQL Server 7.0 | Intermediate /
Brendan Kerry | 8765 since
12/14/2006 5:12:10 AM |
By 1 Users
|
| |
Converts a numeric value to string.
Handles up to 2 decimal places, with rounding.
Can output as dollars and cents.
Inspired by (and thanks to) Leon Tayson
|
| |
| |
| |
 |
 Count Character Or String | Oracle | Advanced /
Andy Archer | 10170 since
4/15/2008 1:08:50 PM |
By 1 Users
|
| |
Without looping, this little PL/SQL stored function returns the number of times a character or string of characters appears in the IN string. With SQL*Plus test script. |
| |
| |
| |
|
Count Characters & Count Digits | Oracle | Advanced /
Andy Archer | 11365 since
1/4/2010 8:55:44 AM | Unrated
|
| |
Without looping, the tiny count_characters PL/SQL stored function returns the count of IN set characters that are in the IN string. Similarly, count_digits returns the count of digits (0123456789). With SQL*Plus test scripts. |
| |
| |
| |
|
Count characters function | SQL Server 2000 | Intermediate /
JaCat | 5334 since
11/4/2004 11:23:31 AM |
By 6 Users
5 Excellent Ratings
|
| |
Allows you to count the number of times a specific character is counted in a string or column. |
| |
| |
| |
|
Count Distinct Characters | Oracle | Intermediate /
Andy Archer | 6503 since
11/25/2008 2:27:25 PM | Unrated
|
| |
This little PL/SQL stored function returns the count of distinct characters in the IN string. With SQL*Plus test script. |
| |
| |
| |
|
Count String UTF Exceptions | SQL Server 7.0 | Intermediate /
Dumitru Radu | 4123 since
10/18/2001 3:28:15 PM | Unrated
|
| |
Find into a string field occurances of a UTF character exception (ScreenShot) |
| |
| |
| |
|
Count the number of occurrences of a particular string pattern | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 8087 since
7/29/2000 9:57:35 PM | Unrated
|
| |
A sample script to count the number of occurrences of a particular string pattern in a text column. This demonstrates how to use PATINDEX with simple SELECT statements. |
| |
| |
| |
|
Count Words | Oracle | Advanced /
Andy Archer | 6656 since
10/21/2010 9:38:08 PM | Unrated
|
| |
Without looping, this tiny PL/SQL stored function returns the number of space-delimited characters and strings in in_string. With SQL*Plus test script. |
| |
| |
| |
|
CountTextFrequency | SQL Server 2000 | Advanced /
Brad G Skidmore | 4738 since
4/6/2004 9:40:23 PM | Unrated
|
| |
Counts the Instances of a String within a String
As well You can pass Patterns or wild cards to be searched and counted. |
| |
(ScreenShot)
