SQL Server: Why to Avoid TRIM functions in WHERE and JOIN clauses

added by lionofdezert
5/4/2011 1:37:33 AM

90 Views

Trim functions (LTRIM & RTRIM) are most favorite function of most developers but how negatively effect these functions on query performance, if these are used in WHERE or JOIN clauses. WHY ??


0 comments