Left() 函数从字符串中提取多个字符(从左侧开始)。
笔记:另请参阅正确的()功能。
Left(
string,
number_of_chars)
Parameter | Description |
---|---|
string | Required. The string to extract from |
number_of_chars | Required. The number of characters to extract. If this parameter is higher than the number of characters in string, this function will return the entire string |
工作于: | 从 Access 2000 |
---|
从 "CustomerName" 列中的文本中提取 5 个字符(从左开始):
SELECT Left(CustomerName, 5) AS ExtractString
FROM Customers;
亲自试一试 »
截取页面反馈部分,让我们更快修复内容!也可以直接跳过填写反馈内容!