ENSC 26 2-3a Questions With Answers

ENSC 26 2-3a Questions With Answers

Using the Comparison Operators (>, <, and =) Example:

If strText1 < strText2 tThen

In this case, VBA performs a character-by-character comparison



True "73" < "9"

' The result of the preceding comparison is ______



True "734" = "734"

' The result of the preceding comparison is ______.



True 3. "aaa" > "aa"

' The result of the preceding comparison is ______.



Like operator The ___________ allows you to specify a pattern.

•The string is then compared against the pattern, and if it matches, the result is True. Otherwise,
the result is False.



? Characters in Pattern in Any single character




* Characters in Pattern in Zero or more characters

, # Characters in Pattern in Any single digit (0-9)




[charlist] Characters in Pattern in Any single character in charlist




[!charlist] Characters in Pattern in not in charlist




Character list (character_list) a special notation for matching any one of a group of
characters. Within a ________, you can specify a range of characters by using the hypen(-).



[ABC] or

[A-C] Range of "A" or "B" or "C"




[A-Z] Range of Any uppercase alphabetic character




[A-Za-z] Range of Any upper-or lowercase alphabetic character




True True or False: ABC" Like "A?C"




True True or False: "A3C" Like "A#C"




False True or False: "ABC" Like "A??C"