Selecting Text not in Upper case

[kime1974]

I am using Crystal 8.5 and XI.

I need to display records that certain field data in not in Upper case. Examples are below:

125 Main Street
45 ELM STREET
45 PORTER CIRCLE
98 Salem Street

I would like the results return:
125 Main Street
98 Salem Street

Thanks!
Kim

 

[lbass]

Please see thread767-1570270.

-LB

 

[AndyMc]

It appears to me that Kim is looking to skip records that are all-caps. Not that I have an answer ...

 

[CoSpringsGuy]

this should work if your skipping records with ALL caps

asc(right(trim({field}),1)) >= 97 and asc(right({field},1)) <= 122


_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[CoSpringsGuy]

asc(right(trim({field}),1)) >= 97 and asc(right(trim({field}),1)) <= 122

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

Yes, I think I misunderstood.

-LB