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!

Register Log in
  • Congratulations derfloh 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

JetRamsey

Technical User
Joined
Oct 22, 2010
Messages
49
Location
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?
 
Sort by date Sort by votes
{field} = uppercase({field})
would be false if the field contains any lower case
 
Upvote 0 Downvote
if strcmp(uppercase({somefield}),{somefield}) <> 0 then 1 (or some other indicator).
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

inkbird01
  • Locked
  • Question Question
Filters &gt; Record Selection for dates between
Replies
4
Views
871
pmax9999
pmax9999
sofseattle
  • Locked
  • Question Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
689
BobSuruncle
BobSuruncle
DSenger
  • Locked
  • Question Question
Percentage Formula for Crystal reports
Replies
13
Views
2K
pmax9999
pmax9999
chish_nc
  • Locked
  • Question Question
show annivesary dates for next quarter
Replies
3
Views
647
chish_nc
chish_nc
T
  • Locked
  • Question Question
Date comparison Formula
Replies
2
Views
2K
TPG_IT
T

Part and Inventory Search

Sponsor

Back
Top