Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

MS Access UCase() Function

Concept visual

MS Access UCase() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Formula

Convert the text in "CustomerName" to upper - case:

SELECT UCASE(CustomerName) AS UppercaseCustomerName

FROM Customers;

Definition and Usage

Formula

The UCase() function converts a string to upper - case.

Tip:

Also look at the

LCase() function.

Syntax

UCase(

text )

Parameter Values

Parameter

Description text

Required. The string to convert

Technical Details

Works in:

From Access 2000

MS Access UCase() Function

Concept visual

MS Access UCase() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Formula

Convert the text in "CustomerName" to upper - case:

SELECT UCASE(CustomerName) AS UppercaseCustomerName

FROM Customers;

Definition and Usage

Formula

The UCase() function converts a string to upper - case.

Tip:

Also look at the

LCase() function.

Syntax

UCase(

text )

Parameter Values

Parameter

Description text

Required. The string to convert

MS Access UCase() Function

MS Access UCase() Function

Example

SELECT UCASE(CustomerName) AS UppercaseCustomerName

Definition and Usage

Tip:

Also look at the

Syntax

UCase(

Parameter Values

Parameter

Description text

Technical Details

Works in:

From Access 2000

Previous

Next

MS Access UCase() Function

MS Access UCase() Function

Example

SELECT UCASE(CustomerName) AS UppercaseCustomerName

Definition and Usage

Tip:

Also look at the

Syntax

UCase(

Parameter Values

Parameter

Description text

Technical Details

Works in:

From Access 2000

Previous

Next