| Assembly | SqlServer.Rules.dll |
| Namespace | SqlServer.Rules.Performance |
| Class | AvoidEndsWithOrContainsRule |
| Id | SRP0002 |
| Friendly Name | Unanchored string pattern |
| Category | Performance |
| Ignorable | true |
| Applicable Types | Procedure |
| Scalar Function | |
| Table Valued Function | |
| View |
Try to avoid using patterns that start with '%' when using the LIKE keyword if possible. (Sargable)
Avoid using patterns that start with '%' with the LIKE keyword (Sargeable)