é®å¸ä¸LEFT(ç¼å·ï¼2)åæ³ä¸ç¬¦åVFPä¸LEFT()å½æ°è¯æ³ï¼å符表达å¼ååæªå åå¼å·ã
LEFTï¼ï¼å½æ°ï¼
ä»å符表达å¼è¿åæå®æ°éçå符ï¼ä»æ左边çå符起ã
è¯æ³ï¼
LEFT(cExpression, nExpression)
è¿åï¼
å符
åæ°ï¼
cExpression
ä»LEFTï¼ï¼å½æ°ä¸è¦è¿åå符çæå®å符表达å¼ã
nExpression
æå®ä»å符表达å¼è¿åçå符æ°ãå¦ænExpression大äºcExpressionä¸çé¿åº¦ï¼åè¿åææçå符表达å¼ãå¦ænExpression为è´æ0ï¼åè¿å空å符串ã
LEFTï¼ï¼å½æ°ä¸SUBSTRï¼ï¼å½æ°èµ·å§ä½ç½®æ¯ç¸åçï¼ä»1ç®èµ·ã
LEFTï¼ï¼å½æ°ç¤ºä¾ï¼
CLEARä¸è¿°ä»£ç ä¸ï¼
LEFT('Redmond, WA', 4)ï¼æ¯ä»æå®çå符表达å¼âRedmond, WAâä¸è¿åå4个å符âRedmâã
LEFT('ç¼å·', 2)ï¼æ¯ä»æå®çå符表达å¼âç¼å·âä¸è¿åå2个ASCIIå符âç¼âï¼è§æ³¨1ã
代ç æ§è¡ç»æè¿è¡çé¢æ¾ç¤ºå¦ä¸å¾ï¼
注1ï¼VFPä¸å符表达å¼ä¸ä¸ä¸ªæ±åæ2个ASCIIå符计ç®ã