Как убрать в столбце лишние символы

REPLACE (Production.Product.Name, ',*', '')

SELECT substr(f, 1, locate(',', f) - 1) 
FROM (
  SELECT 'uuuuuu, hthu' f FROM dual UNION ALL
  SELECT 'oooooo, thth' FROM dual
) a;

SELECT SUBSTRING(Production.Product.Name, 1, locate(',', Production.Product.Name) - 1) 
FROM (
  SELECT 'uuuuuu, hthu' Production.Product.Name FROM Production.Product UNION ALL
  SELECT 'oooooo, thth' FROM Production.Product
) a;

SELECT    Production.Product.Name, SUBSTRING(Production.Product.Name, 0, CHARINDEX(',', Production.Product.Name)) 
FROM Production.Product

SELECT pp.Name,SUBSTRING(pp.Name, 0, CHARINDEX(',', pp.Name)), "ОБЪЕДИНИЛ" = 
      CASE 
         WHEN CHARINDEX(',', pp.Name)>0 THEN SUBSTRING(pp.Name, 0, CHARINDEX(',', pp.Name))
         ELSE pp.Name
      END
  FROM Production.Product AS pp

SELECT  
      CASE 
         WHEN pp.Name IS NULL THEN 'UnpricedNULLNULLNULL'
         WHEN CHARINDEX(' Tights', pp.Name)>0 THEN SUBSTRING(pp.Name, 0, CHARINDEX(' Tights', pp.Name))
         WHEN CHARINDEX(',', pp.Name)>0 THEN SUBSTRING(pp.Name, 0, CHARINDEX(',', pp.Name))
         ELSE pp.Name
      END AS тотото, 
      COUNT(*),
      CAST(SellStartDate AS DATE)
FROM Production.Product AS pp
WHERE SellStartDate >= '20020601' AND SellStartDate < '20060101'
GROUP BY 
      CASE 
         WHEN pp.Name IS NULL THEN 'UnpricedNULLNULLNULL'
         WHEN CHARINDEX(' Tights', pp.Name)>0 THEN SUBSTRING(pp.Name, 0, CHARINDEX(' Tights', pp.Name))
         WHEN CHARINDEX(',', pp.Name)>0 THEN SUBSTRING(pp.Name, 0, CHARINDEX(',', pp.Name))
         ELSE pp.Name
      END,
      SellStartDate
ORDER BY 
      CASE 
         WHEN pp.Name IS NULL THEN 'UnpricedNULLNULLNULL'
         WHEN CHARINDEX(' Tights', pp.Name)>0 THEN SUBSTRING(pp.Name, 0, CHARINDEX(' Tights', pp.Name))
         WHEN CHARINDEX(',', pp.Name)>0 THEN SUBSTRING(pp.Name, 0, CHARINDEX(',', pp.Name))
         ELSE pp.Name
      END