<td class="Griddato" align="center"><%=rsLPProv.Fields("ProPs_BaseSiNo" )%></td>

ProPs_BaseSiNo is a boolean value in the database table. On the ASP page it returns True or False, how can I convert this if it is true or false it returns Yes or No to the user screen?

Dim displayPro
displayPro=<%=rsLPProv.Fields("ProPs_BaseSiNO")%>

<%
If displayPro=True then
displayPro="Yes"
else
displayPro="No"
End If
%>
Then insert displayPro into the appropriate column of the table

Let me know if this helps

John

Worked out like a charm!