2007-03-07 (first published: 2003-06-30)
422 reads
Nagabhushanam Ponnapalli
Initcap Function
INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.
2006-05-29 (first published: 2003-07-02)
661 reads
Using Built in Functions in User Defined Functions
This short article shows an interesting technique for using the SQL built in functions inside a user defined function (UDF).
2003-08-07
6,179 reads
2003-07-02
643 reads
2003-07-02
405 reads
SUBSTR - SUBSTRING function extension
SUBSTR returns a portion of char, beginning at character @StartPos, @Length characters long. If @StartPos is 0, it is treated as 1. If @StartPos is positive, Oracle counts from the beginning of char to find the first character. If @StartPos is negative, Oracle counts backwards from the end of char.
2003-07-02
273 reads
INSTR Function
INSTR searches string for substring. --> position is an integer indicating the character of string where SQL Server begins the search. -->If position is negative, SQL Server counts and searches backward from the end of string. occurrence is an integer indicating which occurrence of string SQL Server should search for. The value of occurrence must […]
2002-11-12
1,364 reads
Blogs
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
PowerShell Strikes Back: Know Your Quotes, Young Padawan
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
A Redgate Data Modeler Gotcha with Relationships
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
Forums
BCA KCU MAGELANG NO TELPON 087781685658
WHATSAPP 087781685658 Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang, Jawa Tengah...
BCA KCU PEKALONGAN NO TELPON 087781685658
WHATSAPP 087781685658 Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa Tengah 51116
Cara buka blokir bank jago terkunci
Cara buka blokir Bank Jago yang terkunci (akun/kartu) paling cepat adalah melalui fitur Lupa...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers