One small correction I see.  In the section "Setting Up a Test" you have your initial version of the BinaryToHex function.  I believe for this to work as written you'll...

• This reply was modified 3 years, 7 months ago by  Larry Huisingh.

It looks like your formula for the LastName causes the first character to be a blank.  You need to start the substring one place further.
SUBSTRING(Name

That makes sense.  If you repeatedly access views with the...

Thank you so much for this article! I've seen and even used these functions a couple of times but I never really understood why they worked the way they...

I've noticed that code in your articles have keywords color-coded. When I try to copy/paste from Query Analyzer or Enterprise Manager into Word I don't get the colors to...

Maybe you could comment on how to set off the code snippets with formatting like you used that allows scrolling. I haven't posted code on this forum before and...

Was any data related to constraints or indexes?  If so, was any of the data using high-order byte values (non-ASCII)?  We had problems importing data that was encrypted using high-order...