Intelligence to generate alternatives when functions are applied to columns

Is it possible that sql optimizer for sql server can have the intelligence to generate alternatives like the one seen in the image?

image