2007-03-07 (first published: 2003-06-30)
403 reads
2007-03-07 (first published: 2003-06-30)
403 reads
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)
552 reads
This short article shows an interesting technique for using the SQL built in functions inside a user defined function (UDF).
2003-08-07
6,098 reads
2003-07-02
562 reads
2003-07-02
296 reads
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
242 reads
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,240 reads
By Andy Warren
I think our profession was the better for having a professional association, even if...
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
This may be a bit non-typical, but I am currently running SQL 2019 Developer...
Hello SSC friends, I am a SQL Developer who is learning how to be...