Tech Crunch

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 Example Convert a string: SELECT StrConv(“SQL Tutorial is cool”, 1) AS ConvertedString; Definition and Usage The

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 Example Return a number as a string: SELECT Str(42) AS ConvertToString; Definition and Usage The Str()

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 Example Return a string with 5 spaces: SELECT Space(5) AS SpaceString; Definition and Usage The Space()

MS Access RTrim() Function Example Remove trailing spaces from a string: SELECT RTrim(“SQL Tutorial    “) AS RightTrimmedString; Definition and Usage

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 Example Replace “i” with “a” in the string: SELECT Replace(“My name is Willy Wonka”, “i”, “a”)

MS Access Mid() Function Example Extract characters from a string, starting at position 3: SELECT Mid(“SQL Tutorial”, 3) AS ExtractString;