Question

Write suitable SQL query for the following:

Display details from 'email' column (attribute), in the 'Students' table, after removing any leading and trailing spaces

Answer 1

SELECT TRIM(email) FROM Students;