I thought this was going to be an article about backing up to one of those portable keyring USB fobs.

Silly me. 

S.

My initial thoughts on reading this was "1 Procedure, the second generates an error".  Finding no option for this, I went for "None, a error will be raised."

Reading the explantion,...

Adam,

Playing with your code turned up an interesting trick:

declare @var varchar(10)

set @var = char(226)

print char(226)

if @var like '[ab]' --> gives 'no'

print 'yes'

else

print 'no'

if @var like '[a-b]' --> gives 'yes'

print...

An obvious (I feel) one not listed that made me very happy when I learned it, is that you can select some of the code and press F5 to execute...