Unanswered: Problem using Convert Function in ISQL
I am using iSQL on Sybase 12.5.1
I am facing the problem while using the convert function for converting Char datatype to Numeric as :
SELECT CONVERT(NUMERIC(11,2), ISNULL(value,'0'))
where value is character type of data in a table, but I have received the following error message
Server Message: Number 249, Severity 16
Server 'prodphx', Line 1:
Syntax error during explicit conversion of VARCHAR value '322,000.00' to a NUMERIC field.
This happened on the data only when there is Numeric data with comma separated and decimal values & give the correct result, if there is only inter data as "123456" etc. How I can convert data with commas and decimal ??