case when 運用

SELECT DISTINCT 
bfir_date AS back_date, vendor, mtype AS [type], msize AS size,
Case When Substring(cus_name,1,3)="(代)" Then 1 Else 2 End As cus_name FROM dbo_ram