I needed a quick way to check whether a string was all uppercase.
Using the InStr function:
InStr ({fieldname},(UpperCase ({fieldname})) ,0 )
The syntax being:
InStr([start,]string1,string2[,compare])
start- an optional starting position
string1,2 - strings to compare
compare - either 0 or 1, 0 being a binary comparison, 1 being textual.
http://msdn.microsoft.com/en-us/library/wybb344c(VS.85).aspx
No comments:
Post a Comment