What is the difference between a VBA private/public function and a SQL Server function?
I'm jumping from Access to SQL Server and VBA to C# sharp now.
In the past when I had an update query I could do the following SQL -
UPDATE tblColTypes SET tblColTypes.Family = Replace_Symbols([Family])
WITH OWNERACCESS OPTION;
And the Replace_Symbols would be in a VBA module as:
Public Function Replace_Symbols(sVlu As String) As Variant
On Error GoTo Err_This
sVlu = Replace(sVlu, "-", "")
sVlu = Replace(sVlu, "/", "")
sVlu = Replace(sVlu, Chr(34), "")
Replace_Symbols = sVlu
How would I do this in C# using Visual Studio 2008 - do I create a SQL Server function in under my Server Explorer window?