Free E-Books

String manipulation functions
String functions manipulate text-based expressions. Here are some common uses of these
functions:
n InStr(): Returns a number that represents the first position of one string in another
string:
n Instr(???abcd123efg234???, ???23???) returns 6, the start position of 23.
n Instr(7, ???abcd123efg234???, ???23???) returns 11??”the 7 in the beginning tells
InStr() to start after position 7 of the string.
n Left(): Returns the leftmost characters of a string:
n Left(???abcdefg???,4) returns ???abcd???.
n Len(): Returns the length of a string:
n Len(???abcdefgh???) results in 8.
n Lcase(): Returns the lowercase of the string:
n Lcase(???Angus Young???) returns angus young.
463
Using Expressions in Queries and VBA Code 13
n LTrim(): Removes leading spaces from a string:
n LTrim(??? abcd???) returns ???abcd???.
n Mid(): Returns characters from the middle of a string:
n Mid(???abcdefgh???,3,4) returns ???cdef???, starting at position 3 and reading 4 characters.


Pages:
956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980