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.
Ввійдіть щоб вподобати
Ввійдіть щоб прокоментувати