Does the query engine guarantee index order of numbers table in the join
with reference to the second example cited in your article.
discussion round the campfire is speculating that if the index isnt in numeric order then the application in the second example will fail with eroneous replacements within the string..
Does anyone have any deeper knowledge to dispell this concern ?
Curious SQL People....