UPPER Function In SQL Server 2008

In this article i will explain how to convert the string in uppercase.
  • 2940

Introduction

UPPER() function is a string function. UPPER() Function converts the string to upper case.

Syntax

select upper (Column_Name) from Table_Name

Example

Suppose we have table named Employee as.

Create-Table-in-sql.jpg

To select the values of the "F_Name" and "L_Name" columns , and convert the "F_Name" column to uppercase.

SQL-Uppercase-function.jpg

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.