I couldn't find TRIM function

Hi,

I found rtrim and ltrim functions, but I didn't find trim, so should I use rtrim(ltrim(' a ' ))? Am I right?

cheers,

Alessandro Camargo

In 2000? Yes. In 2005 trim() exists.|||There is no TRIM function in TSQL even in SQL Server 2005. You probably saw the SSIS function. You have to use RTRIM(LTRIM()) in any version of SQL Server.|||

yes, I saw the SSIS function, there is no TRIM.

thanks.............

sql