Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

MS Access LCase() Function

Concept visual

MS Access LCase() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Formula

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

SELECT LCASE(CustomerName) AS LowercaseCustomerName

FROM Customers;

Definition and Usage

Formula

The LCase() function converts a string to lower - case.

Tip:

Also look at the

UCase() function.

Syntax

LCase(

text )

Parameter Values

Parameter

Description text

Required. The string to convert

Technical Details

Works in:

From Access 2000

MS Access LCase() Function

Concept visual

MS Access LCase() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Formula

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

SELECT LCASE(CustomerName) AS LowercaseCustomerName

FROM Customers;

Definition and Usage

Formula

The LCase() function converts a string to lower - case.

Tip:

Also look at the

UCase() function.

Syntax

LCase(

text )

Parameter Values

Parameter

Description text

Required. The string to convert

MS Access LCase() Function

MS Access LCase() Function

Example

SELECT LCASE(CustomerName) AS LowercaseCustomerName

Definition and Usage

Tip:

Also look at the

Syntax

LCase(

Parameter Values

Parameter

Description text

Technical Details

Works in:

From Access 2000

Previous

Next

MS Access LCase() Function

MS Access LCase() Function

Example

SELECT LCASE(CustomerName) AS LowercaseCustomerName

Definition and Usage

Tip:

Also look at the

Syntax

LCase(

Parameter Values

Parameter

Description text

Technical Details

Works in:

From Access 2000

Previous

Next