SQL Tip: Avoid Applying Functions to Table Data

(Ember Crooks) One of the top SQL tips on many lists for developers of SQL is to avoid applying a function to the table data. I think of this as avoiding funcitons on the left of my comparison operator (=, !=, >, <, etc) - though that's a simplification that may not always be correct. [membership level="0"] [pmpro_button level="14" text="Read More - Register for Free Membership"][/membership] [membership][standout-css3-button href="http://db2commerce.com/2013/11/18/sql-tip-avoid-applying-functions-to-table-data/" opennewwindow=true]Read More[/standout-css3-button] (Community content)
[/membership]