In the end i used powershell script like below to change Encoding to ASCII and that did the trick

Get-ChildItem "PathToYourFolder" -Filter *.xml |

ForEach-Object{

$file=Get-Content $_.FullName

$file | Set-Content -Encoding...

I can't unfortunately.

So, script task is the way to go and C#.

I see what i can do.

Thank you!

Awesome!

It works as i wanted to!

Many, many thanks!

Thank you very much for your answers!

That works like a charm. Thank you very much.
Best regards

Thank you very much for a response.
Unfortunatelly, i can't alter or add any functions on the server.

Tom, thank you very much for replying. 
It is my mistake that i haven't mentioned in first post that this conversion takes place in the WHERE clause, so actual data...

Thanks for replying @ronkyle.
Because i don't have underlying key in base table i've decided to stick with a table approach.

Thanks for all replies.
The view is part of a model used in PowerBI. I wanted to build a system that will containt main table with all necessary data....

Thank you for reply.
Unfortunatelly, i don't have client identifier in originating table

This info changes my decision. I will leave data as it is and i'll try to solve...

Well, unfortunately i still don't know what i am doing wrong.
I've attachted PrintScreen from my installation window of VS 2017 where it can be seen that i've checked SSDT...

Thank you very much for your reply.
I'll try to go with your advice.
Best regards.
Lukas

Thank you for reply, that solves my problems.

Hi, 
Thanks for reply but what i meant is whether i can expect version for sql server 2016 or 2017?