SQL Server Performance Forum – Threads Archive

searches

currently: ex.
IF @LastName <> ” BEGIN
SET @SQLWhere = @SQLWhere + ‘ AND I.LastName LIKE @LastName + ”%”’
new reqirement to allow for: LIKE ”%”’ [email protected] + ”%”’ But this will kill us on performance. any good options here for keeping this search fast?

---

]]>