SQL Server Performance

searches

Discussion in 'General DBA Questions' started by bfarr23, Mar 3, 2005.

  1. bfarr23 New Member

    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?


Share This Page