ulowsurr  uscalar

Chapter 2: Transact-SQL Functions

upper

Description

Returns the uppercase equivalent of the specified string.

Syntax

upper(char_expr)

Parameters

char_expr

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

Examples

Example 1

select upper("abcd")
---- 
ABCD

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute upper.

See also

Function lower





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

View this book as PDF