LCASE
更新时间:2025-10-17
描述
将参数中所有的字符串都转换成小写。
别名
- LOWER
语法
SQL
1LCASE ( <str> )
参数
参数 | 说明 |
---|---|
<str> |
需要被转换成小写的字符串 |
返回值
参数 <str>
转换成小写的字符串
举例
SQL
1SELECT LOWER("AbC123"),LCASE("AbC123")
Text
1+-----------------+-----------------+
2| lower('AbC123') | lower('AbC123') |
3+-----------------+-----------------+
4| abc123 | abc123 |
5+-----------------+-----------------+
6```",
7 "language": "zh-CN"
8}
9---
10
11<!--
12Licensed to the Apache Software Foundation (ASF) under one
13or more contributor license agreements. See the NOTICE file
14distributed with this work for additional information
15regarding copyright ownership. The ASF licenses this file
16to you under the Apache License, Version 2.0 (the
17"License"); you may not use this file except in compliance
18with the License. You may obtain a copy of the License at
19
20 http://www.apache.org/licenses/LICENSE-2.0
21
22Unless required by applicable law or agreed to in writing,
23software distributed under the License is distributed on an
24"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
25KIND, either express or implied. See the License for the
26specific language governing permissions and limitations
27under the License.
28-->
29
30## 描述
31
32将参数中所有的字符串都转换成小写。
33
34## 别名
35
36- LOWER
37
38## 语法
39
40```sql
41LCASE ( <str> )
参数
参数 | 说明 |
---|---|
<str> |
需要被转换成小写的字符串 |
返回值
参数 <str>
转换成小写的字符串
举例
SQL
1SELECT LOWER("AbC123"),LCASE("AbC123")
Text
1+-----------------+-----------------+
2| lower('AbC123') | lower('AbC123') |
3+-----------------+-----------------+
4| abc123 | abc123 |
5+-----------------+-----------------+