Ignore special characters in search query

vinayiyervinayiyer Member Posts: 4
We have a requirement in NAV 2016 to ignore special characters while searching for records. Eg: if the item No. is '123.456/001' and user enters '123456001' while searching it should still return the record with value '123.456/001'.

Answers

  • StefanTStefanT Member Posts: 2
    Probably would be fastest to create a new automatically updated field which contains the Item No. without the special characters and run the query against the new field.
  • archer89archer89 Member Posts: 337
    agree with stefant.
    best regards
    Franz Kalchmair, MVP
    Alias: Jonathan Archer

    please like / agree / verify my answer, if it was helpful for you. thx.
    Blog: http://moxie4nav.wordpress.com/
Sign In or Register to comment.