Employees table has an VehicleNum column. It is of

Employees table has an VehicleNum column. It is of a varchar type and is used to store vehicle numbers (for example, 'A338МВ38').
Which condition should be used to fetch a vehicle number whose third and firth characters are '74'?

WHERE VehicleNum LIKE ‘_74%’
WHERE VehicleNum [2,2] = ‘74’
WHERE VehicleNum LIKE ‘%74%’
WHERE LEFT (VehicleNum, 2,2) = ‘74’
WHERE VehicleNum LIKE ‘_74’

Explanation

WHERE VehicleNum LIKE ‘_74%’ is the correct answer
"_" symbol replaces single character in a string.
"%" symbol replaces character sequence of arbitrary length.
Therefore, '_74%' pattern will return all records whose second and third characters are 7 and 4 correspondingly.