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.

This sounds like a good time to use a User Defined Function to keep all of the ugly stuff out of your query.<BR><BR>--The Dan ... Is NVARCHAR in SQL Server the same or similar to VARCHAR2 in Oracle?

A SQL statement using CONVERT() looks like the following: Advertisement. Article continues below this ad. ... NCHAR for international Unicode data or NVARCHAR for variable-length Unicode.

Build an example web host in ASP.NET ... Below is the script you can use to create a log table in the SQL Server database. CREATE TABLE [Log] ( [Id] int IDENTITY(1,1) NOT NULL, [Message] nvarchar ...