您位於此處:
MID
從文字字串中間指定的起始位置傳回指定數目的字元。
使用
MID(text, start_num,
num_chars),將 文字取代為傳回字元時要使用的欄位或運算式;將 start_num 取代為左側要作為起始位置使用的字元數;將 num_chars 取代為要傳回的字元總數。
MID(Division, 3, 4) 會傳回以左側第三個字元開頭的 分部名稱四個字元。在使用者記錄上,這代表部門代碼。
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.