The problem with some of this weird functions is... you use it so sparingly that when you need it you forget the syntax and their meaning...
I've never developed a stored procedure longer than 30 lines without even going once to BOL even when I know what functions to use... I just simply don't remember parameters and details about the ANSI/non ANSI behavior...
I wish I had a chip inserted in my brain so I don't have to read every page in BOL 10 times!
Do any of you guys know about a good and easy to learn memorization technique?