Mar 14, 2014 #1 JetRamsey Technical User Oct 22, 2010 49 US CR version 14 I would like to make some corrections to a database. How can I identify if a field has any lower case letters in it?
CR version 14 I would like to make some corrections to a database. How can I identify if a field has any lower case letters in it?
Mar 14, 2014 1 #2 Charliy Programmer Aug 12, 2008 601 US {field} = uppercase({field}) would be false if the field contains any lower case Upvote 0 Downvote
Mar 14, 2014 1 #3 kray4660 MIS Apr 7, 2008 1,054 US if strcmp(uppercase({somefield}),{somefield}) <> 0 then 1 (or some other indicator). Upvote 0 Downvote