StrConv() and StrReverse() Function in MS Access

1. StrConv() function :
In MS Access ,The StrConv() function returns a converted strings.In this, we will pass first parameter string and second parameter conversion.

Possible values for conversion
1	For upper-case
2	For lower-case
3	For the first letter of every word to upper-case
4	For narrow characters to wide
16	For Hiragana into Katakana (Japan only)
32	For Katakane into Hiragana (Japan only)
64	For Converts to unicode
128	For Unicode to default page code

Syntax :

StrConv(string1, conversion)

Example-1 :

SELECT StrConv("GeeksforGeeks", 1) AS ConvertedString;

Output –

ConvertedString

GEEKSFORGEEKS

Example-2 :

SELECT StrConv("geeks for geeks", 3) AS ConvertedString;

Output –

ConvertedString

Geeks For Geeks

2. StrReverse() function :
In MS Access,The StrReverse() function reverse the given string.In this function, a string will be passed and it will return the reversed string.

Syntax :

StrReverse(string)

Example-1 :

SELECT StrReverse("Geeksforgeeks") AS StringReverse;

Output –

StringReverse

skeegrofskeeg

Example-2 :

SELECT StrReverse("Gfg") AS StringReverse;

Output –

StringReverse

gfG