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