SQL Function: TRIM()

Definition:

Return provided string that removed the space characters before the first character and after the last character.

TRIM(string)

Table PLAYER

Input:

SELECT UID,TRIM(MESSAGE) AS MESSAGE FROM STUDENT;

Output:

‘NO head and NO tail.’By secondary 6 student