Mid Century Modern (approx 1930 to 1965) ( Specialty)

SELECT * FROM PromoSubcategory WHERE dbo.StringClean(SubCategoryDesc) = 'Mid-Century-Modern-approx-1930-to-1965' Mid Century Modern (approx 1930 to 1965) ( Specialty)