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
My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.