Easy to Create, Easy to Change - Easy to use!

Function::String

Lower

Lower(TEXT VALUE) Lower("My Camel Case TEXT) Lower("MY CAPITAL TEXT") Lower(MyTextField)

The lower function converts each letter in a specified text value into lower-case type.


Parameters


TEXT VALUE

The Text String that you want to change to lower case.

Returns/Result


The specified text value with all the letters in lower case.

Examples


Examples

lower( "DataEase" )

Returns: dataease


lower( "Club ParaDEASE" )

Returns: club paradease


lower( LAST NAME)

Returns: The value in the LAST NAME field in lower-case type for every record that is processed. If a record contains the value Birnbaum in the LAST NAME field, the function returns birnbaum.


Reference

lower

Type

Text Function

Purpose

The lower function converts each letter in a specified text value into lower-case type.

Syntax

lower( TEXT VALUE)

Returns

The specified text value with all the letters in lower case.

Examples

lower( "DataEase" )

Returns: dataease

 

lower( "Club ParaDEASE" )

Returns: club paradease

 

lower( LAST NAME)

Returns: The value in the LAST NAME field in lower-case type for every record that is processed. If a record contains the value Birnbaum in the LAST NAME field, the function returns birnbaum.

See Also


Proper Upper StringReplace MemoReplace

On the forum about Lower

DataEase 8.1 is slower than 6.52 when I save a big table

I'm doing some testing on Dfw 8.1.1.1464 now, I'm just comparing this version with dfw 6.52.Ho an application with  a table with 900,000 records with many fields and virtual. This application has been migrated to the version 8.1 DFW Well i...

Product: Dataease [{8}]FIVE. Written by Marco 18/02/14 at 09:49:30

Re:DataEase 8.1 is slower than 6.52 when I save a big table

Hi Marco. 1. If you are doing this on a local drive (c:/d: etc) the problem is most likely that you run Shared Local Database in 8.1 when 6.x is running Single User mode. This means that DE8 is running locking operations on local drive, w...

Product: Dataease [{8}]FIVE. Written by DataEase 18/02/14 at 09:50:33

DataEase 6.5-- to 8.5, migrates but it's much slower

We want to move to 8.5, but every time we download a trial version and run it with our existing data we have something that is slow slow slow.  Reports that give results immediately with the old software, take minutes t...

Product: Dataease [{8}]FIVE. Written by Bonnie Clarke 21/11/16 at 18:20:40

Re:DataEase 6.5-- to 8.5, migrates but it's much slower

Hello there,I have already made the change some time ago. I could not, however, notice this problem. Rather, on the contrary, many functions are much faster than before! Maybe one would have to check the existing scripts if small traps...

Product: Dataease [{8}]FIVE. Written by Markus 21/11/16 at 18:39:50

Re:Re:DataEase 6.5-- to 8.5, migrates but it's much slower

I sure wish we did not have the problem, but we do.  I hope someone has a lead for us to follow, to fix it.  It's not just one report, but everything we have tested....

Product: Dataease [{8}]FIVE. Written by Bonnie Clarke 21/11/16 at 21:20:25

Re:DataEase 6.5-- to 8.5, migrates but it's much slower

HiHave done similar migrations, and performance was never an issue.  On the contrary is gets a lot better......I would try Remove the indexes on each form, save form, re-open again and rebuilt indexes.  You sai...

Product: Dataease [{8}]FIVE. Written by Josef Vella 22/11/16 at 11:00:31

Re:Re:DataEase 6.5-- to 8.5, migrates but it's much slower

The problem is that between 6.x and 8.0 there is a version called 7 which have a lot of behaviour changes which made it close to impossible for DFW 6.x users to migrate to 7.x without a lot of work.We have done a lot in 8.x do improve the migr...

Product: Dataease [{8}]FIVE. Written by DataEase 23/11/16 at 16:17:25

On the blog about Lower