MarkLogic Server 11.0 Product Documentation

sql:trim

sql:trim(
   $str as xs:string
) as xs:string

Summary

Return a string that removes leading and trailing empty spaces in the input string.

Example

  sql:trim("             this is text    ")
  => this is text