>HI
>
>I have a c# CLR that I'm using to decrypt bank sort codes and account number.
>
>I've has an error that caused SQL to restart
>
>A fatal error occurred in the .NET Framework common language runtime. SQL Server is shutting down. If the error recurs after the server is restarted, contact Customer Support
>
>This seems to occur when I use the CLR in a table update rather than just decrypting one row.
>
>so
>
> update integra_live.dbo.xmasall set sortcode_decrypt = dbo.fn_RMB_RemoveCharacters(dbo.fn_RMB_bank_decrypt([Sort Code],@decrypt_key), '^0123456789') where [DD reference] = 'RWM000196'
>
>works
>
>and
>
> update integra_live.dbo.xmasall set sortcode_decrypt = dbo.fn_RMB_RemoveCharacters(dbo.fn_RMB_bank_decrypt([Sort Code],@decrypt_key), '^0123456789')
>
>fails
>
>any ideas why there should be this differnce
>
>as an extra confusion bith statements work perfectly on my development server.

Is your development machine running against the same DB ?
If not then I'd guess Naomi is right : bad data (or your function/s not handling some variation correctly)