select case when length(trim(col1)) > 2 then substr(trim(col1),1,length(trim(col1))-2) else col1 end result from test;这时,对去掉空格后的长度大于2的去掉最后两个字符,对小于等于2的(0,1,2)同样按保留原样进行处理,如果有需要可以进行修改为如下形式:select case when length(trim(col1)) > 2 then substr(trim(col1),1,length(trim(col1))-2) when length(trim(col1)) = 2 then else col1 end result from test;
case
when length(trim(col1)) > 2 then substr(trim(col1),1,length(trim(col1))-2)
else col1 end result
from test;这时,对去掉空格后的长度大于2的去掉最后两个字符,对小于等于2的(0,1,2)同样按保留原样进行处理,如果有需要可以进行修改为如下形式:select
case
when length(trim(col1)) > 2 then substr(trim(col1),1,length(trim(col1))-2)
when length(trim(col1)) = 2 then
else col1 end result
from test;