Hi!

Well, I posted the main idea of checking. All other things could be added to expression, following is what I get:

!(cName=='') AND iif(plWorkingWithTable,len(cName)<=10,len(cName)<=128) AND ;
(IsAlpha(cName) OR left(cName,1)=='_') AND ;
chrtran(upper(cName), "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ_", "") == ""

plWorkingWithTable should be .T. if field is for table (10 characters)

Note that you can remove underscore if you will ever use commands that cause bug with underscore-started field names (see message#479278).



>>Hi!
>>
>>llIsIdentifier = IsAlpha(cName) and chrtran(upper(cName), "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ_", "") == ""
>>
>
>Actually, the lead character can be an underscore (_) as well, and unless the name is a long name in a DBC, it can't exceed 10 characters.
>
>>
>>
>>>Is there a function in Foxpro to tell me if a name is a valid field name or do I have to write this myself?
>>>
>>>It seems like i've seen it somewhere but I can't seem to find it.