SELECT 1 FROM mytable WHERE room1 <> LOWER(room1) TO SCREEN NOCONSOLE IF _TALLY > 0 * _TALLY records have uppercase letters ENDIF>i have a field called room1 with about 100 records. the field should contain lower case characters and numbers.
>use mytable >scan for room1 # " " >if IsUpper(room1) = .t. >wait window "upper" >endif >endscan >>