TRIM( ) is not working in sql server ??

If TRIM( ) is not working in sql server Then u can use the foll. function

" LTRIM ( RTRIM ( items ) ) "  instead  of  "TRIM( items )"

Query:
 
 SELECT LTRIM(RTRIM( field_name )  FROM Table_name

Ex :

 SELECT LTRIM ( RTRIM ( UserName )  FROM tbl_studentDetails