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 1=1 order by Category asc