I agree with you Brandie,

The Point is, I guess, is to try hard to reduce or limit the use of functions in a WHERE clause when and where you can.

If you cant, you cant.

same concept as using Temp Tables and cursors.

Reduce them as much as possible but sometimes you gotta do what you gotta do.

As DBAs, Architects, Engineers, we just need to have a good understanding of the ramifications of our decisions. BUT,.....at some point the rubber hits the road and we gotta make a choice. Sometimes the choices arent ideal.

Great discussions here.

GAJ