MSSQL›String Functions›TRIM
←RTRIM

TRIMString Functions

REPLACE→

Removes leading and trailing spaces (or specified characters).

Syntax

TRIM([chars FROM] str)

Example

Enter values below to update the example in real time.

employees→
name→
UPDATE employees SET name = TRIM(name);