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 –
Last Updated :
01 Sep, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...