ä¸ãå符串为æ°å¼ï¼å¯ä»¥ç´æ¥ä½¿ç¨ cast æå转æ¢ææ°å¼åï¼ç¶åç¨max()åæ大å³å¯ï¼
å¦ï¼select max(cast(å段 as integer))
äºãå符ä¸é´å å«æ°åï¼å¦ 137465ã5453728ï¼æ大为7ï¼8,å¯ä»¥ä½¿ç¨CHARINDEX ( )å½æ°æ¥å¤æ
å¦ï¼
ä¸ãæå®ä½ç½®çæ°åï¼å¦ abc02,a2u07,æ大æ°å为07æ7ï¼å¯ä»¥ä½¿ç¨rightæleftæªåæ°åï¼å使ç¨max()
å¦ï¼select max(right(å段,2))
å½ç¶è¿æå ¶ä»æ¹å¼çæ°åæ¯è¾ï¼åºæ¬æè·¯ç¸åï¼å å®ä½æ°åçä½ç½®ï¼ææªåæ°åï¼å¨è¿è¡æ¯è¾ã