SELECT DISTINCT REPLACE(convert(varchar,Category),SUBSTRING(convert(varchar,Category), PATINDEX('%[^a-zA-Z0-9 '''''']%', convert(varchar,Category)), 1),'') as Category FROM SPF_LISTING WHERE (category='Apartment' or category='Villa' or category='Penthouse' or category='Terraced' or category='Lofts' or category='Bungalow' or category='Duplex' or category='Additional Parking Space' or category='Podium Villa') and Listtype=1 order by Category asc