Case sensitive find?

[soulicious]

Is it possible to do a case sensitive find? I have a field that contains a lowercase "a" which stands for one thing, and a capital "A" which stands for something else (all this data is imported so I have no control over the data inputting; i.e it has to be big "A" and little "a").

At this point whenever I do a find for any "a", I get big and small. Are there any workarounds for finding based on case sensitivity short of going through each record one at a time and changes big "A"s to something else? Any calculations that recognize case sensitivity that I could use to easily change all big "A"s to "Q" or something..?

Thanks!

Sol

[-Queue-]

Set the indexing language, under the Storage tab in field options, to Unicode.

[soulicious]

Awesome!!! You saved the day. Thanks.