SQL Server ä¸æªåå符串常ç¨çå½æ°ï¼
1.LEFT ( character_expression , integer_expression )
å½æ°è¯´æï¼LEFT ( 'æºå符串' , 'è¦æªåæ左边çå符æ°' )
è¿åä»å符串左边å¼å§æå®ä¸ªæ°çå符
select LEFT('SQL_Server_2008',4 );
è¿åç»æï¼SQL_
2.RIGHT ( character_expression , integer_expression )
å½æ°è¯´æï¼RIGHT ( 'æºå符串' , 'è¦æªåæå³è¾¹çå符æ°' )
è¿åå符串ä¸ä»å³è¾¹å¼å§æå®ä¸ªæ°ç integer_expression å符
select RIGHT('SQL_Server_2008',4 );
è¿åç»æï¼2008
3.SUBSTRING ( character_expression , start , length )
å½æ°è¯´æï¼SUBSTRING ( 'æºå符串' , 'æªåèµ·å§ä½ç½®(å«è¯¥ä½ç½®ä¸çå符)' , 'æªåé¿åº¦' )
è¿åå符ãbinaryãtext æ image 表达å¼çä¸é¨å
select SUBSTRING('SQL_Server_2008',5 ,6);
è¿åç»æï¼Server
温馨提示:内容为网友见解,仅供参考