Did you read the article mentioned?
What version of SQL are you using?
Can you post the query that you're using (the relevant parts)?
Thank you for quick respond.
I sure read the article.
I've found the reason. Source table data was not cleaned up at all. Too many special characters, spaces in between of numbers etc.
That's what finally worked for me:
CASE WHEN ISNUMERIC(column)= 1 THEN
CAST(CAST(REPLACE
(REPLACE
(REPLACE
(REPLACE
(REPLACE
(column,' ','')
,CHAR(13),'')
,CHAR(10),'')
,CHAR(13),'')
,CHAR(10),'')
as VARCHAR(10)) AS Numeric(18,0))
ELSE 0 END ResultColumnName
Might look redundant but finally worked only this way.
I had to use this new column to join to numeric column in another table.
SQL Server 2008 R2.
It was urgent request and I am very glad to find fast help here.
Thank you very much!