Hello everyone,

what does charindex return when an expression is not found in another?
(Not a case of exp1 or exp2 being null). Will that be -1 or is it still
NULL? BOL doesn't say anything

thanks.

Daniel

MS Sql Server LazyDBA home page