Your answer is here.

There's no way I know of doing this.

Your likely alternatives would appear to be

1. Ensuring that T1 and T2 are well indexed and querying them separately, or
2. Combining T1 and...

Here's a quicker way. And are you sure you want to allow NULLs?

DROP TYPE IF EXISTS dbo.ColumnTableType;

CREATE TYPE dbo.ColumnTableType AS TABLE
(
    Column NVARCHAR(MAX) NULL
);

HI, and thanks for the reply. I do have a full version of VS, but am not familiar with how you do what you do in SSMS in there?...

There's only one column and it...

Defining the column as NVARCHAR(MAX) would be a safer option. I'm sure that you'll need Unicode support for some of the characters in those languages.

--Edit: you should also probably read...

• This reply was modified 7 years, 1 months ago by Phil Parkin.

There is no fast way of doing this. As Eric mentioned, DOCX files are zipped XML files.

Searching through them would involve unzipping them first.

So you want to search the text embedded inside a DOCX file that has been stored inside a VARBINARY column, is that right?

So, notionally, like this?

SELECT cols...

Once the varbinary data has been SELECTed, what do you want to happen to it next.

Using poorly defined terms like 'read' and 'extract' does not make it clear exactly what...

What do you wish to read it with, or how do you wish to process it?

Hi Phil, I can assure you I did a google search before reaching out to the forum.  If you can't assist with the inquiry, then please don't insult users...

Which kind of raises the question of why he would need to have different permissions in access vs whatever other application.  Or if there are only certain tables he needs...

  Yeah the deny on his personal...

Wouldn't that also (badly) affect his rights in GP?

Out of interest, what is stopping him from connecting right now?