Case-Based Critical Thinking Questions Case 1 - Human Resources Application
An application used by the Human Resources (HR) department needs to be improved. You need to use various string manipulation properties and methods to ensure all data entered by a user is accurate and stored correctly.
The application needs to process benefits for full-time employees only. Which of the following statements determines whether the strEmpCode variable contains an employee code for a full-time employee?
A) If strEmpCode Like "[A-Z]#####"
B) If strEmpCode.ToUpper Like "F####"
C) If strEmpCode Like "F*"
D) If strEmpCode Like "!F*"

Question

Quizplus · Accepted Answer

Option C uses the wildcard character (*) to match any character(s) coming after the "F" in the employee code, indicating that the code belongs to a full-time employee. Option A checks for any uppercase letter followed by five digits, while option B checks for an uppercase "F" followed by four digits. Option D, using the negation operator (!), checks for any employee code that does NOT start with "F", which does not meet the requirement of processing benefits for full-time employees only.