Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check for Case Sensitivity 2

Status
Not open for further replies.

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?
 
{field} = uppercase({field})
would be false if the field contains any lower case
 
if strcmp(uppercase({somefield}),{somefield}) <> 0 then 1 (or some other indicator).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top