dash is the name of a numeric variable and dash is a string variable
Answers
Answered by
0
Dash1 is a numeric variable that identifies the location of the first hyphen in EmployeeID (and later dash variables identify the first hyphen in the ever-shrinking employrem).
CHAR.INDEX(EmployeeID,'-') finds the first '-' in the string in EmployeeID
CHAR.INDEX(EmployeeID,'-') finds the first '-' in the string in EmployeeID
Similar questions