Transform a string into a different format or case.
| SELECT StrConv(“SQL Tutorial is cool”, 1) AS ConvertedString; |
The StrConv() function converts a string to a specified format or case.
| StrConv(string1, conversion, LCID) |
|
Parameter |
Description |
|
string1 |
Required. Specifies the string that will undergo conversion. |
|
conversion |
Required. Specifies the type of conversion to apply to the string. Possible values: 1: Convert to uppercase 2: Convert to lowercase 3: Convert the first letter of every word to uppercase 4: Convert narrow characters to wide 16: Convert Hiragana to Katakana (Japanese specific) 32: Convert Katakana to Hiragana (Japanese specific) 64: Convert to Unicode 128: Convert from Unicode to the default page code. |
|
LCID |
Optional. Specifies the LocaleID to use for the conversion. If not provided, the function uses the system LocaleID. |
|
Works in: |
From Access 2000 |
Transform the content of a string.
| SELECT StrConv(“SQL Tutorial is cool”, 2) AS ConvertedString; |
Transform the content of a string.
| SELECT StrConv(“SQL Tutorial is cool”, 3) AS ConvertedString; |