row_count  set_appcontext

Chapter 2: Transact-SQL Functions

rtrim

Description

Returns the specified expression, trimmed of trailing blanks.

Syntax

rtrim(char_expr | uchar_expr)

Parameters

char_expr

is a character-type column name, variable, or constant expression of char, varchar, nchar, or nvarchar type.

uchar_expr

is a character-type column name, variable, or constant expression of unichar or univarchar type.

Examples

Example 1

select rtrim("abcd    ")
--------
abcd

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute rtrim.

See also

Function ltrim





Copyright © 2005. Sybase Inc. All rights reserved. set_appcontext

View this book as PDF