SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2009

String Manipulation - CHARINDEX()

I see charindex used quite commonly in string manipulation.  What I rarely see used is the optional third parameter.  Here I will explain how to use it, a situation where it can be useful and something to be careful of.


CHARINDEX ( expression1 ,expression2 [ , start_location…

Read more

4 comments, 3,663 reads

Posted in Never Say Never on 19 December 2009

Tally Table - Character Date Validation

Tally (or numbers) tables are one of my favorite query writing tools.  Such a simple premise that can be applied to a wide variety of problems.   If you don't know what they are, I'd recommend this article.   Here is one problem I've seen a few times now that you… Read more

8 comments, 2,922 reads

Posted in Never Say Never on 14 December 2009