Example
Convert a string:
sql
SELECT StrConv("SQL Tutorial is cool", 1) AS ConvertedString;
Definition and Usage
The StrConv() function returns a converted string.
Syntax
text
StrConv(string1,
conversion,
LCID)
Parameter Values
| Parameter | Description |
|---|---|
| string1 | Required. The string to be converted |
| conversion | Required. The type of conversion to perform. Possible values: 1: Convert to upper-case2: Convert to lower-case 3: Convert the first letter of every word to upper-case4: Convert narrow characters to wide16: 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 |
Technical Details
| Works in: | From Access 2000 |
|---|
More Examples
Example
Convert a string:
sql
SELECT StrConv("SQL Tutorial is cool", 2) AS ConvertedString;
Example
Convert a string:
sql
SELECT StrConv("SQL Tutorial is cool", 3) AS ConvertedString;