Advertising Memorabilia ( Specialty)

SELECT * FROM PromoSubcategory WHERE dbo.StringClean(SubCategoryDesc) = 'Advertising-Memorabilia' Advertising Memorabilia ( Specialty)