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?

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.