SQL 查询显示冒号以后内容

Question

表qs_customers 有字段name怎么让结果显示‘：’（冒号）以后内容
在线等，谢谢！select name from qs_customersNAME                                               
---------------------------------------------------
10mW CS:40MW-PICO-IADP                             
10mW CS:ACS-OADP                                   
10mW CS:Null                                       
10mW CS:PICO-CTL     

Answer 1

Ltrim(c1,[c2]) 去掉c1左边所包含的C2任何字符

Answer 2

substr（name ，instr(name,':')）

Answer 3

select substr(name,instr(name,':')+1)from qs_customers
这样对了 Ltrim(c1,[c2]) 没用出来～～

Answer 4

select substr(name,instr(name,':')+1) from aaa;