var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: PatIndex vs Like
My tests show both of them perform exactly the same... any conditions where either one may have an advantage ???
Get yourself a copy of the The Holy Book
order has no physical Brett in The meaning of a Kaiser . -database data
If you are looking for PATINDEX = 1 and the predicate is on an indexed column.
Like can seek. Patindex will scan.
ur codings are working excelent.
You can also use PATINDEX in a substring function but LIKE doesn't work so well.