I’ve had some data imported into SQL through a UI that has a � instead of the correct character such as ö for example.

I’m having trouble querying the � as it brings back no results. I’m to replace all of the � with the correct characters.

Any ideas on how to proceed without changing any main database properties?

Thanks