<div>
Correct me if i'm wrong but it seem that you have duplicated records.<br />
<br />
You can simply filter them with a where clause like that :<br />
<br />
Sql = &quot;&quot;<br />
Sql = Sql &amp;&nbsp;&quot;Insert into Distinct_Diagnoses [Desc] &quot;<br />
Sql = Sql &amp;&nbsp;&quot; select distinct [Diagnosis] from PATIENT_PROBLEMS WHERE [Diagnosis] NOT LIKE '?%&quot;
</div>


Correct me if i'm wrong but it seem that you have duplicated records.

You can simply filter them with a where clause like that :

Sql = ""
Sql = Sql & "Insert into Distinct_Diagnoses [Desc] "
Sql = Sql & " select distinct [Diagnosis] from PATIENT_PROBLEMS WHERE [Diagnosis] NOT LIKE '?%"

<div>
ok, thanks - that might just be the trick . Many thanks <br />
<br />

</div>


ok, thanks - that might just be the trick . Many thanks



<div>
<div class="content wysiwyg-content">
Hi Experts <br />
I have a routine to generate a list of unique diagnoses from some health records, but I need to remove the question marks<br />
<br />
Sql = &quot;&quot;<br />
Sql = Sql &amp;&nbsp;&quot;Insert into Distinct_Diagnoses [Desc] &quot;<br />
Sql = Sql &amp;&nbsp;&quot; select distinct [Diagnosis] from PATIENT_PROBLEMS &quot;<br />
<br />
is giving me <br />
?Asthma<br />
Asthma<br />
?Stroke<br />
Stroke<br />
etc<br />
<br />
The following change to the SQL gives a &quot;type mismatch&quot; error <br />
Sql = Sql &amp;&nbsp;&quot;select distinct '&quot; &amp;&nbsp;(Replace [Diagnosis] , [?], &quot;&quot;&nbsp;) &amp;&nbsp;&quot;'&quot;<br />
<br />
Any other way of doing the necessary &quot;replace''? <br />
<br />
Many thanks <br />
<br />

</div>
</div>


Hi Experts 
I have a routine to generate a list of unique diagnoses from some health records, but I need to remove the question marks

Sql = ""
Sql = Sql & "Insert into Distinct_Diagnoses [Desc] "
Sql = Sql & " select distinct [Diagnosis] from PATIENT_PROBLEMS "

is giving me 
?Asthma
Asthma
?Stroke
Stroke
etc

The following change to the SQL gives a "type mismatch" error 
Sql = Sql & "select distinct '" & (Replace [Diagnosis] , [?], "" ) & "'"

Any other way of doing the necessary "replace''? 

Many thanks 



Using'replace'in SQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.