Error Converting data type nvarchar to numeric

[former_member781837]

Hi experts,

I'm sitting with an issue with a formatted search currently.

The FMS looks like this:

SELECT $[$38.14.NUMBER] FOR BROWSE

This works for anything under 999 but as soon as it goes over 1,000 i get the error as it says in the title.

It seems that the , in the number is screwing us around. How can i get past this without changing the display options?

Thanks

Reinhardt

[Former Member]

Hi Reinhardt,

You do not need for browse here.

Try: SELECT $[$38.14.number\]

Thanks,

Gordon