that works neatly thank rick.
k

>>i have a field called room1 with about 100 records. the field should contain lower case characters and numbers.
>>i would like to run quick checks on all entries to make sure there are no upper case in the filed entries. is there a way to do this collectively without running through the whole file. i wrote this, which works, but i suspect there is a way to do this without going through the file piecemeal.
>>all i want is an alert, not an inventory.
>>
>>

>>use mytable
>>scan for room1 # " " 
>>if IsUpper(room1) = .t.
>>wait window "upper"
>>endif
>>endscan
>>

>>
>>thanks for any suggestions.
>>
>>k
>
>
>Try to process individual records:
>

SCAN FOR NOT EMPTY(room1) and ISUPPER(room1)
>    * Any records processed here meet your criteria
>ENDSCAN

>
>If you're just looking to see if any exist:
>

COUNT FOR NOT EMPTY(room1) and ISUPPER(room1) TO lnBadRecords
>IF lnBadRecords != 0
>    * Signal the user
>ENDIF