Loading lesson path
Concept visual
Start at both ends
SELECT StrConv("SQL Tutorial is cool", 1) AS ConvertedString;The StrConv() function returns a converted string.
string1, conversion,
)
Required. The string to be converted conversion Required. The type of conversion to perform.
Formula
1: Convert to upper - case
2: Convert to lower - case
3: Convert the first letter of every word to upper - case4: 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
Optional. The LocaleID. If omitted, this function uses the system LocaleID
SELECT StrConv("SQL Tutorial is cool", 2) AS ConvertedString;SELECT StrConv("SQL Tutorial is cool", 3) AS ConvertedString;❮ MS Access Functions