select
A,
B,
C,
replace(right(l_name, 3),'-','') as screen,
from table_name
这句话就是,选l_name字段中的右边三个字符,并且如果有‘-’,就去掉
select
A,
B,
C,
replace(right(l_name, 3),'-','') as screen,
from table_name
这句话就是,选l_name字段中的右边三个字符,并且如果有‘-’,就去掉