If you function is a function in your .NET app then what Leo told you won't work. When you execute the update the command is sent to SQL Server and evaluated by SQL Server (which knows nothing about your app/function.)
To use your .NET function you'll need to process each record individually in your application to get the value for each record and then submit the UPDATE with the value (rather than with the call to CreateSalt.)
>Can I use my own function in a SQL update?
>
>Ex: UPDATE IntranetUsers SET salt = CreateSalt(5)
>
>When I try to run this I get 'CreateSalt' is not a recognized function name.
>
>Am I going about this the wrong way?
>
>I have a table that I need to update this field in. I need to use a function I created that generates a value and then store it in this field used by my encryption function.
>
>TIA
>Brad
Hector Correa