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("w3wiki", 1) AS ConvertedString;
Output –
| ConvertedString |
| w3wiki |
Example-2 :
SELECT StrConv("Beginner for Beginner", 3) AS ConvertedString;
Output –
| ConvertedString |
| Beginner For Beginner |
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("w3wiki") AS StringReverse;
Output –
| StringReverse |
| skeegrofskeeg |
Example-2 :
SELECT StrReverse("Gfg") AS StringReverse;
Output –
| StringReverse |
| gfG |