Mid() 函数从字符串中提取一些字符(从任意位置开始)。
Mid(
string,
start,
length)
Parameter | Description |
---|---|
string | Required. The string to extract from |
start | Required. The start position |
length | Optional. The number of characters to extract. If omitted, this function returns all characters from the start position |
工作于: | 从 Access 2000 |
---|
从一列文本中提取字符(从位置 4 开始,提取 6 个字符):
SELECT Mid(CustomerName, 4, 6) AS ExtractString
FROM Customers;
亲自试一试 »
截取页面反馈部分,让我们更快修复内容!也可以直接跳过填写反馈内容!