http://support.microsoft.com/kb/842421

Explains how to redo the certificate key (*.snk)

This question was stumbled across by myself when trying to determine the maximum amount of RAM allowable on a Standard Edition of SQL Server 2000.  Imagine my disappointment to discover...

This should do it.  A case statement that checks to see if the Charindex is zero. 

CASE WHEN CHARINDEX( b.orig_val, ' + @col_name + ' )=0

      THEN CONVERT( VARCHAR( '...

"Invalid length parameter passed to the substring function. The statement has been terminated."  error appears for the statement below:  (possibly because the childlastname field may well be null or blank...