These functions cause index scan. I have not done deep analysis, but I am assuming it will similar to any scan operation.

You are right. Its still in preview mode but you can try it on Azure SQL right now.

Thank you so much for your inputs. I'll try to come up with second part of this article.

I Found an issue in this approach, if I start this job from step#2 it doesnt return correct result.

For your reference, following is the query I used (hope not missing...

Links for code listing are not working :w00t: