Realizing data in Uppercase

  • Thread starter Thread starter Mota
  • Start date Start date
M

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.
 
Try using the VBA function StrComp

StrComp(UCase(dName),dName,0)

Will return 0 if Uppercase dName is equal to dName
 
Thats just what i was searching for.Thank you.

John Spencer (MVP) said:
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.
Click to expand...
Click to expand...
 
Back
Top