我有一個字段AA﹐為字符型﹐它的內容為X+Y+Z。其中X和Z都為任意個字母字符﹐Y為任意個數字字符﹐
現我要得到X+Y﹐即去掉后而的Z
倒AA的內容為﹕'BR0021GD ' 我要的為'BR0021'
'E0003P ' 我要的為'E0003'
select left(zzhh,len(ltrim(rtrim(zzhh)))+1-patindex('%[0-9]%',reverse(ltrim(rtrim(zzhh))))) from t_bom
如何得到重復記錄
SQL﹕select top 1 count(*) cs,字段1 from table1 group by 字須1 order by count(*) desc
VFP﹕ select top 1 count(*) cs,字段1 from table1 group by 字須1 order by cs desc