2007-03-07 (first published: 2003-06-30)
402 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)
543 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,087 reads
2003-07-02
562 reads
2003-07-02
263 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
241 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,223 reads
Blogs
SQL Clone Works with FILESTREAM
By Steve Jones
SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...
Fun and profit with UTF-8
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...
Data Platform MVP 2020
I am humbled to be among so many great professionals and honored at the...
Forums
Removing TDE from a Database: Level 4 Stairway to TDE
Comments posted to this topic are about the item Removing TDE from a Database:...
Database Modeling - Relationships
Comments posted to this topic are about the item Database Modeling - Relationships
Read database objects relationship in easy steps
Comments posted to this topic are about the item Read database objects relationship in...
Ask SSC