THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access StrConv() Function

❮ MS Access Functions

Example

Convert a string:

SELECT StrConv("SQL Tutorial is cool", 1) AS ConvertedString;
Try it Yourself »

Definition and Usage

The StrConv() function returns a converted string. 

Syntax

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-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

Technical Details

Works in: From Access 2000

More Examples

Example

Convert a string:

SELECT StrConv("SQL Tutorial is cool", 2) AS ConvertedString;
Try it Yourself »

Example

Convert a string:

SELECT StrConv("SQL Tutorial is cool", 3) AS ConvertedString;
Try it Yourself »

❮ MS Access Functions