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]

Still the same error without the browse.

I think i need to convert the number somehow. For example:

If the price is 1,500 i need to convert it to 1500 (without the comma).

because if i take off the thousand seperator under administration - system initialisation - General - display, it works well.

[vasileiosfasolis]

Hi

try to use define it as you said from administration by replacing the comma

Edited by: Fasolis Vasilios on Nov 23, 2011 2:55 PM