Using the CLR Function Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined ...

What Is Tsql Function? Users-defined functions are Transact-SQL or CLRS (common language runtime) routines that take parameters, perform actions, such as complex calculations, and return the results ...

In-Depth Top 7 Features Coming to SQL Server 2016 SQL 2016 has a number of major enhancements which will help whether or not you are implementing on-prem, in Azure or in a hybrid model. By Joey D ...

8) Don't Rename Script-Based Objects You'll often create a script-based object, such as a view, a stored procedure, or a user-defined function. SQL Server then stores the script that created the ...

I realize this is a pretty old thread, but I would also say that if 4000 characters isn't big enough for your text search, T-SQL Full Text search probably isn't the right tool either.