如何金属类别厚度中最后面的A排除,保留A前面的数值呢
其中SQL 语句是
SELECT UserDeFine2 as 厚度 FROM xxx
SELECT replace(UserDeFine2,'A','') as 厚度 FROM xxx
-- SELECT replace(UserDeFine2,"A","") as 厚度 FROM xxx