Skip to content
Related Articles

Related Articles

Improve Article
StrConv() and StrReverse() Function in MS Access
  • Last Updated : 01 Sep, 2020

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
1For upper-case
2For lower-case
3For the first letter of every word to upper-case
4For narrow characters to wide
16For Hiragana into Katakana (Japan only)
32For Katakane into Hiragana (Japan only)
64For Converts to unicode
128For 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
Recommended Articles
Page :