Transportation, Gas, Vehicles ( Specialty)

SELECT * FROM PromoSubcategory WHERE dbo.StringClean(SubCategoryDesc) = 'Transportation-Gas-Vehicles' Transportation, Gas, Vehicles ( Specialty)