Answer to Question #210453 in Databases | SQL | Oracle | MS Access for Burh

Question

_ is used to specify gap between cells

Answer 1

The underscore (_) - It is used when matches one character.

In the MS access, we use the question mark (?) on the place of underscore (_) to match any one character.

SELECT * FROM table_name
WHERE column LIKE '_XXXX