目录

MS Access StrConv() 函数

示例

转换字符串:

SELECT StrConv("SQL Tutorial is cool", 1) AS ConvertedString;
亲自试一试 »

定义和用法

StrConv() 函数返回转换后的字符串。

语法

StrConv( string1, conversion, LCID)

参数值

Parameter Description
string1 Required. The string to be converted
conversion Required. The type of conversion to perform.

Possible values:
1: Convert to upper-case
2: Convert to lower-case
3: Convert the first letter of every word to upper-case
4: Convert narrow characters to wide
16: Converts Hiragana into Katakana (Japan only)
32: Converts Katakane into Hiragana (Japan only)
64: Converts to unicode
128: Converts from Unicode to default page code
LCID Optional. The LocaleID. If omitted, this function uses the system LocaleID

技术细节

工作于: 从 Access 2000

更多示例

示例

转换字符串:

SELECT StrConv("SQL Tutorial is cool", 2) AS ConvertedString;
亲自试一试 »

示例

转换字符串:

SELECT StrConv("SQL Tutorial is cool", 3) AS ConvertedString;
亲自试一试 »