Realizing data in Uppercase

[Mota]

Hi;
I know that VBA is not a Case Sensitive Programming Language (unlike C++ or
Delphy),but in a special case,i need to verify that.Otherwise,i have to
check near 2000 records manually.My question is:
Can i separate all records of [MainTable] having data in the Text field
[dName] in Upper Case?In other word,is there a function like "IsUpperCase"
or "IsCapital" to use in Where clause of SQL statements !?
Thank you for your help.

 

[John Spencer (MVP)]

Try using the VBA function StrComp

StrComp(UCase(dName),dName,0)

Will return 0 if Uppercase dName is equal to dName

 

[Mota]

Thats just what i was searching for.Thank you.

Try using the VBA function StrComp

StrComp(UCase(dName),dName,0)

Will return 0 if Uppercase dName is equal to dName

Hi;
I know that VBA is not a Case Sensitive Programming Language (unlike C++ or
Delphy),but in a special case,i need to verify that.Otherwise,i have to
check near 2000 records manually.My question is:
Can i separate all records of [MainTable] having data in the Text field
[dName] in Upper Case?In other word,is there a function like "IsUpperCase"
or "IsCapital" to use in Where clause of SQL statements !?
Thank you for your help.