Firearms/Weapons/Militaria ( Specialty)

SELECT * FROM PromoSubcategory WHERE dbo.StringClean(SubCategoryDesc) = 'Firearms-Weapons-Militaria' Firearms/Weapons/Militaria ( Specialty)