Question

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'?

Cosmo · Accepted Answer

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.

Cosmo · Accepted Answer

WHERE VehicleNum LIKE ‘_74%’

Cosmo · Answer

WHERE VehicleNum [2,2] = ‘74’

Cosmo · Answer

WHERE VehicleNum LIKE ‘%74%’

Cosmo · Answer

WHERE LEFT (VehicleNum, 2,2) = ‘74’

Cosmo · Answer

WHERE VehicleNum LIKE ‘_74’

Слідкуй за CodeGalaxy

Мобільний додаток Beta