select WTPARTNUMBER,NAME from wcuser.WTPARTMASTER 
where WTPARTNUMBER LIKE '%.DRW' or WTPARTNUMBER LIKE '%.drw' Or 
WTPARTNUMBER LIKE '%.ASM' or WTPARTNUMBER LIKE '%.asm' Or 
WTPARTNUMBER LIKE '%.PRT' or WTPARTNUMBER LIKE '%.prt' 
order by WTPARTNUMBER