Radios and Phonographs ( Specialty)

SELECT * FROM PromoSubcategory WHERE dbo.StringClean(SubCategoryDesc) = 'Radios-and-Phonographs' Radios and Phonographs ( Specialty)