TRIM function [String]

TRIM function [String]

Removes leading and trailing blanks from a string.

Syntax

TRIM( string-expression )

Parameters

Returns

Remarks

See also

Standards and compatibility

SQL/2008 The TRIM function is a SQL/2008 core feature.
SQL Anywhere does not support the additional parameters trim specification and trim character, as defined in SQL/2008. The SQL Anywhere implementation of TRIM corresponds to a TRIM specification of BOTH.

For the other TRIM specifications defined by the SQL/2008 standard (LEADING and TRAILING), SQL Anywhere supplies the LTRIM and RTRIM functions respectively.

Example

Discuss this page in DocCommentXchange.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0