MS Access StrConv() Function

Posted by

MS Access

StrConv()

Function

Example

Convert a string:

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


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;

Example

Convert a string:

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