bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access StrConv() Function

Example

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

ParameterDescription
string1Required. The string to be converted
conversionRequired. 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
LCIDOptional. The LocaleID. If omitted, this function uses the system LocaleID

Technical Details

Works in:From Access 2000

Previous

MS Access StrComp() Function

Next

MS Access StrReverse() Function