I have changed my standard SP ProductLoadAllPaged to include this:
--SKU (exact match) partial sku search
IF @SearchSku = 1
SET @sql = @sql + '
FROM Product p with (NOLOCK)
WHERE p.[Sku] LIKE ''%' + @OriginalKeywords + '%'''
But this doesn't work with Ajax filters on, I have noticed there is a SP specific to ajax filters. Is there a way to make the partial sku search as I need it for my site but also want to use the filters.