IO gave this a try but got an incorrect syntax error:

USE [NBCC_Search]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

Create Function [dbo].[fn_iReplaceSpecialCharacters] (@TempString AS NVARCHAR(150))

I changed my fields to nvarchar but it appears maybe that 'REPLACE' has its limits... should I be using another function that uses Unicode? Any T-SQL examples?

I may have stumbled on the answer you mentioned about nvarchar vs. varchar... here with nvarchar in another table it renders properly:

This is a database whose table list names, cities, streets, etc. using the Romanian alphabet, so it is rife with these four characters.

DDL of the Table from which I attempted a view:

USE [NBCC_Search]
GO

/****** Object: Table [dbo].[Professional]  Script Date: 2/2/2017 4:40:24 PM ******/
SET ANSI_NULLS ON
GO

I thought of creating a view such as:

USE [NBCC_Search]
GO
DROP VIEW [dbo].[SpecialRomanian]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[SpecialRomanian]
AS

I used the above example to create another function with no problems until testing it:

Create Function [dbo].[fn_iReplaceSpecialCharacters] (@TempString AS VARCHAR(100))
RETURNS TABLE WITH SCHEMABINDING
AS RETURN
SELECT replace(replace(

Here's a start from the above post, but this has a lot of new concepts to me so lots of errors are popping up so this obviously needs some work...

Here's what I used:

ALTER Function [dbo].[fn_ReplaceSpecialCharacters] (@TempString AS NVARCHAR(100))
RETURNS NVARCHAR(100)
AS
BEGIN
RETURN @TempString COLLATE Latin1_General_BIN
END
GO

USE [NBCC_Search]
GO
SELECT [ContactId]
  ,[FirstName]

Still same problem with nvarchar

Hmm... Problem persists... even the test comes back as ÀAlbèert ËEîinSsStêeiìn ÌInstìitúutëe

I found the problem... I didn't need the word VALUES or the parentheses.

I'm not following the placing of the literal amounts into the SQL. Shouldn't I just be using field names/:

SELECT 100.00, 54215 UNION ALL

SELECT 125.00, 53252 UNION ALL

SELECT 110.00, 63225 UNION...

I went through the GUI with it failing the 'test connection'. I'm trying to put together some code in VBA/Access that I could use to push the data when someone...