>>Use ISNUMERIC() function
>>
>>
>>UPDATE Client SET Amount2 =
>>CASE WHEN ISNUMERIC(Amount ) = 1 THEN CAST(Amount AS INT) ELSE 0 END)
>>
>
>Thanks, this is good to know.
If you're using SQL Server 2012 or later, check TRY_CAST() function.
If it's not broken, fix it until it is.
My Blog