select top 100 *,(CASE WHEN type = 'c' THEN 'category.asp?category_id=' WHEN type = 'p' THEN 'product.asp?prodid=' WHEN type = 'h' THEN 'news.asp?newsno=' end) linkstr from srh_cph (nolock) where partnerid='rwd1899' and type<>'c' and (1=1 and toltext like '%patricia%' and toltext like '%barber%' ) order by (CASE WHEN type = 'c' THEN 1 WHEN type = 'p' THEN 2 WHEN type = 'h' THEN 3 END) asc, clickC desc