thanks for the reply.
NotePad++ can be good solution for own use or for light use. 
for the end user it can not be a clean usage.
the solution must...

the only reason for upgrading to 2016 is the utf-8 encoding witch comes with it

meanwhile i tried another approach than succeeded:

set @xml=(select xml_data from FCSD.DBO.XmlImport)

set @xml_convert=cast(@xml as nvarchar(max));

IF OBJECT_ID('tempdb..##x') IS...

thanks a lot

I'll give it a try

OK

I see what you mean

but what about xml that exceed the varchar(max)?

adding it manually is not an option

is there an option to do it with modify or insert command?

any idea how to divide the xml to chunks?

thanks for the reply and the willingness to help

I'm not familiar with PowerShell or other scripting language besides sql

any assistance will be wonderful

sam

with

ALTER TABLE Elmn DROP CONSTRAINT PK_Elmn

i get:

Server: Msg 3725, Level 16, State 1, Line 1

The constraint 'PK_Elmn' is being referenced by table 'ElmSh', foreign key constraint 'FK_ElmSh_Elmn'.

Server: Msg 3727, Level...

because it is primary key index droping the index fail

i mean how to use the clustering key so i can do something like:

select clientname from tbl where "clustering key" =@x 

or

select "clustering key" from tbl where  clientname=@y 

in shortly...

thank's a lot, you were very helpfull

is there a way to know the location (row number)

of a certain record in a clustered table?

how can i have a clustered index on clientname when clientname can't be uniqe?

when i export  hebrew text stored in access table (with the OutputTo method) to excel file

i expect to get hebrew also in the excel file.

it's work's right with access 2000/xp/2003...