Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Advanced Find question CRM 4.0 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Is it possible to use advanced find to return for example:

    all records where a field is in UpperCase or
    all records where the field content is more than 3 characters?

    Thanks

    Edwin
    Tuesday, April 21, 2009 1:17 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    I believe not.  I don't recall and functions other than 'starts wiith'.  You're going to have to query a filtered view directly.  You have len() for your character count.  Unfortunately, it appears the CRM data bases don't set up with case sensitivity.  So 'name = upper(name)' is not a working filter.
    Tuesday, April 21, 2009 2:24 PM