MS Access StrReverse() Function Example Reverse a string: SELECT StrReverse(“SQL Tutorial”) AS StringReverse; Definition and Usage The StrReverse() function reverses
MS Access StrConv() Function
MS Access StrConv() Function Example Convert a string: SELECT StrConv(“SQL Tutorial is cool”, 1) AS ConvertedString; Definition and Usage The
MS Access StrComp() Function
MS Access StrComp() Function Example Compare two strings: SELECT StrComp(“SQL Tutorial”, “SQL Tutorial”) AS CompString; Definition and Usage The StrComp()
MS Access Str() Function
MS Access Str() Function Example Return a number as a string: SELECT Str(42) AS ConvertToString; Definition and Usage The Str()
MS Access Split() Function
MS Access Split() Function Example Split strings: SELECT Split(“SQL Tutorial is fun!”) AS SplitString; Result: {“SQL”, “Tutorial”, “is”, “fun!”} SELECT Split
MS Access Space() Function
MS Access Space() Function Example Return a string with 5 spaces: SELECT Space(5) AS SpaceString; Definition and Usage The Space()
MS Access RTrim() Function
MS Access RTrim() Function Example Remove trailing spaces from a string: SELECT RTrim(“SQL Tutorial “) AS RightTrimmedString; Definition and Usage
MS Access Right() Function
MS Access Right() Function Example Extract 4 characters from a string (starting from right): SELECT Right(“SQL Tutorial is cool”, 4)
MS Access Replace() Function
MS Access Replace() Function Example Replace “i” with “a” in the string: SELECT Replace(“My name is Willy Wonka”, “i”, “a”)
MS Access Mid() Function
MS Access Mid() Function Example Extract characters from a string, starting at position 3: SELECT Mid(“SQL Tutorial”, 3) AS ExtractString;