How can you search for the sign & in for example Customer name

Schollin_01

Hi, I wonder if someone knows if there is some kind om workaround when it comes to searching for the sign & in for example Customer name in NAV.

As I understand it, the sign & is a reserved sign so I understand why.
Anyone who knows?

Best regards
Karin

Wisa123

To do this, you must include the filter expression that contains the symbol in quotation marks (''). For example, if you want to filter on records that start with the text S&R, the filter expression is 'S&R*'.

https://msdn.microsoft.com/en-us/library/hh879066(v=nav.90).aspx

Wisa123

To do this, you must include the filter expression that contains the symbol in quotation marks (''). For example, if you want to filter on records that start with the text S&R, the filter expression is 'S&R*'.

https://msdn.microsoft.com/en-us/library/hh879066(v=nav.90).aspx

Schollin_01

Thank you, this works fine I thought I tried with '' but somehow I must have mad somthing wrong.

Schollin_01

By the way, does enyone know other reserved signs in NAV?

Kishorm

See the following link for special symbols that can be used in filters...

https://msdn.microsoft.com/en-us/library/hh879066(v=nav.90).aspx

Schollin_01

Hi Kishorm, thanks for your reply. But I mean if there is more reserved signes as & that one has to search for with ''.

Kishorm

Yes I know, basically all the special symbols in the link I sent have a special meaning/function during filtering and so would need be be enclosed in '' in the same way as with the & sign if you wanted to search for data containing those symbols.

Near the top (in the "important" box) it also states..

There may be instances where field values contain these symbols and you want to filter on them. To do this, you must include the filter expression that contains the symbol in quotation marks ('').