Re: SQL Serious Challenge # 1 - Probably Not Much Fun

> Of course, with Indexes it is a word ( to signify an option) not a function .

True, but they had to build the functionality to reverse a string for reverse key indexes. Once you build that function, why not just make it a stored function? Similar to BITAND. They needed it for internal operations. And now you can use it as an operator if you want.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"