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_member781837 · Accepted solution]

Gordon,

You're right, i just noticed that the field is a rate field. Would this be possible to convert then to numeric?

[Former Member · Accepted solution]

Change the type may not be possible if there value exists in the UDF. You need recreate a new UDF.