[Hidden-tech] Filemaker question

[Ian Fraser]

I believe that a calculated field evaluating 
If (Exact (Upper (field1) ; field1) ; "False" ; "True")
will be True if there are any lower-case letters in field1, False if there are no lower-case letters in field1, and blank if field1 is empty (assuming the check box for "Do not evaluate if all referenced fields are empty" is checked.


On Feb 28, 2013, at 4:58 PM, David Korpiewski wrote:

>   ** Be sure to fill out the survey/skills inventory in the member's area.
>   ** If you did, we all thank you.
> 
> 
> A hopefully quick filemaker question to the gurus on this list.  I need 
> to have a query that will find all lowercase entries in a table.  So for 
> example:
> 
> field1:
> -----------
> KTM12000
> stm124124
> ABC02323
> 
> In this situation the query would return me the "stm124124" because that 
> is the entry with a lowercase characters in it.   Creating a calculated 
> field is ok too.
> 
> Ideas?  Please message me offline.
> 
> Thank you kindly
> David
> 
> 
> 
> 
> -- 
> -----------------------------------------
> David Korpiewski
> Software Specialist I
> Department of Computer Science
> University of Massachusetts
> Phone: 413-545-4319
> Cell: 413-695-2191
> Skype: ayrobotech
> -----------------------------------------
> _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
> 
> You are receiving this because you are on the Hidden-Tech Discussion list.
> If you would like to change your list preferences, Go to the Members   
> page on the Hidden Tech Web site.
> http://www.hidden-tech.net/members
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20130301/b293fdd1/attachment.html