MS Access StrConv() Function

Convert a string:

SELECT StrConv("SQL Tutorial is cool", 1) AS ConvertedString;

Definition and Usage

The StrConv() function returns a converted string.

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

Works in:	From Access 2000

Convert a string:

SELECT StrConv("SQL Tutorial is cool", 2) AS ConvertedString;

Convert a string:

SELECT StrConv("SQL Tutorial is cool", 3) AS ConvertedString;