How can I filter *

pranav-joshipranav-joshi Member Posts: 46
I have a table in that one field have many records having wild card charcter *, and I want to filter it. I have used *@\** then *@'*'* then *@** then *..* then *@/** but none of these worked.

Pranav Joshi
MS Dynamics NAV Consultant
SBS Group Desert Mountain (Formerly Silverware Inc.)

Comments

  • BeliasBelias Member Posts: 2,998
    Can you order the records by that field?in this way you'll have all the records beginning with that character in a row...
    otherwise, the only way i know is to do
    SETRANGE(field,'*');
    
    but the user can't do it, you have to put a button with this code
    Also the "find" feature (not the instruction, the ctrl+f) works fine.
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • krikikriki Member, Moderator Posts: 9,110
    [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.