[thelist] Friday Freebie

[Scott Dexter]

I can't take credit for this one, it goes to another guy here at work

<tip type="SQL Server 7" subject="fergit thems doubling up on the single
quotes">
How's this for a sexy trick. Instead of replacing single ticks (') with two
('') so that SQL Server likes them, wrap the entire string in square
brackets, like so: [Jeff O'Malley]

Not only does that save processing time to do the search and replace, it
also covers up other special characters that may be lurking in the string.
</tip>

sgd
--
work: http://ti3.com/
non: http://thinksafely.org/