Civil War Memorabilia ( Specialty)

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