After upgrading to Version 3.8, the store search does not search SKU field

Hi, thanks to the new version 3.8.

I have upgraded my system from 3.5 to 3.8 (via 3.6, 3.7 etc). Before I worked on SQL Procedure to make the search including the SKU field too as follows. In the new 3.8, I could not find out where to upgrade the SQL code. Please help.

thanks in advance!

James


FYI The following was the code which I had to change before and worked great!

Find the store procedure --ProductLoadAllPaged  

Instead of  

  --SKU
    IF @SearchSku = 1
          BEGIN
      SET @sql = @sql + '
      UNION
      SELECT p.Id
      FROM Product p with (NOLOCK)
      WHERE '
      IF @UseFullTextSearch = 1
        SET @sql = @sql + 'CONTAINS(p.[Sku], @Keywords) '
      ELSE
        SET @sql = @sql + 'PATINDEX(@Keywords, p.[Sku]) > 0 '
    END


Use

  --SKU
    --IF @SearchSku = 1
          --BEGIN
      SET @sql = @sql + '
      UNION
      SELECT p.Id
      FROM Product p with (NOLOCK)
      WHERE '
      IF @UseFullTextSearch = 1
        SET @sql = @sql + 'CONTAINS(p.[Sku], @Keywords) '
      ELSE
        SET @sql = @sql + 'PATINDEX(@Keywords, p.[Sku]) > 0 '
    --END