Actually I found a function written in another post....
https://www.sqlservercentral.com/forums/topic1001736-391-1.aspx

CREATE FUNCTION RemoveNonASCII
(
 @nstring nvarchar(255)
)
RETURNS varchar(255)
AS
BEGIN

 DECLARE @Result varchar(255)

Do not reply,....  I am ok with the following SQl that I found in some website. Works well!
So my next question:
I need to convert those illegal ( out...

I FOUND THE ANSWER.....
NO NEED TO REPLY PLEASE... The following works
So I get my count of 3 

If( object_id('tempdb..#t') is not null )DROP TABLE #t;

IGNORE THE ABOVE POST-- I was wrong 
Help me here please ... I need to count the distinct codes between a range. So the output I am expecting is 2...

One solution might be for me to add a where  clause that says
WHERE CODE BETWEEN 'D0100' AND 'D0103'

That wont work for me. Why ?
I plan to...

Yeas...

Thank you .. In the mean time I figured out...
I dont think we need to give a name to a constraint..  So the script works 

IF EXISTS...

Here is my next question
I have a need to load new data into   dbo.NPI100
However before I do that I like to make a backup copy of the table.