ISNULL(LEFT (@field2,len(@field2)) +RIGHT(Replicate('0',(@field3-1))+LTRIM(CAST(SUBSTRING((ISNULL((select max(khbh) from tbl_xx_kh where patindex('%[^0-9]%',khbh)=0 ),@field2+Replicate('0',(@field3-1))+'0')),(len(@field2)+1),@field3) AS BIGINT)+1),@field3),@field2+Replicate('0',(@field3-1))+'1')
为空默认值: ISNULL ('huang','0001' )
长度: len ( ' huang' ) 5
重复: Replicate( ' 0 ' , 4 ) 0000
开头空白移除: LTRIM (' huang' ) huang
类型转换: CAST ( '0001 ' AS BIGINT) 1
截断位置: SUBSTRING ( ' huang ' , 2 , 3) uan (“值”,“开始截断的位置”,“保留的位置”)
只包含值为数字: patindex('%[^0-9]%',khbh)=0)