True. comparetype works the same as in the other string functions

True. comparetype works the same as in the other string functions we

have discussed. If you want to use comparetype, you must use include.

§ Split(expression,delimiter,count,comparetype) takes a string and

splits it into an array of strings. expression is the string to be split up. If

expression is zero length. Split returns an array of no elements,

delimiter is a string that indicates what is used to separate the sub-strings

in expression. This is optional; by default the delimiter is the space. If

delimiter is zero length (""), an array of one element consisting of the

whole string is returned, count is used to specify a maximum number of

sub-strings to be created. The default for count is -1, which means no

limit. If comparetype is 0, a binary comparison is performed, and

uppercase letters are distinct from lowercase letters. If comparetype is 1, a

textual comparison is performed, and uppercase and lowercase letters are

the same. comparetype is only useful when the delimiter you have chosen

is a letter.

§ Join(stringarray,delimiter) does just the opposite of Split. It takes

an array of strings and joins them into one string, using delimiter to

separate them. delimiter is optional; the space is the default.

Other functions

§ LBound(array) returns the smallest valid index for array.

§ UBound(array) returns the largest valid index for array.

§ Asc(string) returns the ANSI character code for the first character of

string.

§ Chr(integer) returns a string consisting of the character that matches the

ANSI character code specified by integer.

§ Array(value1, value2, ..., valueN) returns an array containing the

specified values. This is an alternative to assigning the values to array

elements one at a time.