A Vet. If the nearest school wasn't 4 hours away (ok, AND another 4 years of school), I probably would have already swapped...

someone found this for me:

in BOL under Create Procedure:

"If the logic of the stored procedure is dependent on a particular setting, include a SET statement at the start of the...

make the quote into two single quotes something like this:

select 'O''Malley'

or programatically: REPLACE(col, '''', '''''')

dl

Here's a great site that lists a ton of them:

http://www.devasp.net/Net/Articles/Randy/TraceFlags.asp

granted, it doesn't list 8602...

dl