Open In App

StrConv() and StrReverse() Function in MS Access

Improve
Improve
Like Article
Like
Save
Share
Report

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

Last Updated : 01 Sep, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads