SQL CHARINDEXå½æ°è¿åå符æè å符串å¨å¦ä¸ä¸ªå符串ä¸çèµ·å§ä½ç½®ãCHARINDEXå½æ°è°ç¨æ¹æ³å¦ä¸ï¼
CHARINDEX ( expression1 , expression2 [ , start_location ] )
Expression1æ¯è¦å°expression2ä¸å¯»æ¾çå符ä¸ï¼start_locationæ¯CHARINDEXå½æ°å¼å§å¨expression2ä¸æ¾expression1çä½ç½®ã
SQL CHARINDEXå½æ°è¿åä¸ä¸ªæ´æ°ï¼è¿åçæ´æ°æ¯è¦æ¾çå符串å¨è¢«æ¾çå符串ä¸çä½ç½®ãåå¦SQL CHARINDEXå½æ°æ²¡ææ¾å°è¦æ¾çå符串ï¼é£ä¹å½æ°æ´æ°â0âãçä¸é¢çå½æ°å½ä»¤æ§è¡çç»æï¼
CHARINDEX('SQL', 'Microsoft SQL Server')è¿ä¸ªå½æ°å½ä»¤å°è¿åå¨âMicrosoft SQL Serverâä¸âSQLâçèµ·å§ä½ç½®ï¼å¨è¿ä¸ªä¾åä¸ï¼CHARINDEXå½æ°å°è¿åâSâå¨âMicrosoft SQL Serverâä¸çä½ç½®11ã
æ¥ä¸æ¥ï¼çè¿ä¸ªCHARINDEXå½ä»¤ï¼
CHARINDEX('7.0', 'Microsoft SQL Server 2000')å¨è¿ä¸ªä¾åä¸ï¼CHARINDEXè¿åé¶ï¼å 为å符串â7.0â ä¸è½å¨âMicrosoft SQL Serverâä¸è¢«æ¾å°ã