2007-03-07 (first published: 2003-06-30)
407 reads
2007-03-07 (first published: 2003-06-30)
407 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)
574 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,150 reads
2003-07-02
575 reads
2003-07-02
350 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
245 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,288 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
This is one of those things that on hindsight was a stupid problem, but...
Hi Expert, I wanted to calculate max date for prodstatus =5 - min date...
Hello guys, I am preparing for Azure DE positions with Data Factory, Databricks, Synapse....
OK so I have a customer with a hosted website with eCommerce options. Essentially...