soulicious Posted April 12, 2006 Share Posted April 12, 2006 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 Link to comment Share on other sites More sharing options...
-Queue- Posted April 12, 2006 Share Posted April 12, 2006 Set the indexing language, under the Storage tab in field options, to Unicode. Link to comment Share on other sites More sharing options...
soulicious Posted April 12, 2006 Author Share Posted April 12, 2006 Awesome!!! You saved the day. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6580 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now