This is working but I am looking soothing like a scaler function that can be used in Select statement. Any idea?

select ..., dbo.fnExpressionToValue(Expr)

from myTable

How about following:

SQL SERVER AGENT --> Alerts -->SQL Server Perfomance condition for alert type --> Under Performance condition alert definition --> locks under OBJECT --> Under Counter select lock wait...