database if statement with conditions

[fran7]

Hi, I wonder if anyone can advise.
One database field is never empty as I have a text editor that inputs <P>&nbsp;</P> even if I dont actually put any text. I need to check with an if statement if the field has either <P>&nbsp;</P> and "<br>" & vbCrLf
and if so write, no data availabel and if not write the field text.


I have this but it doesnt seem to do the trick

<%
If Trim(PDFavQuote) = "" OR Trim(PDFavQuote) = "<P>&nbsp;</P>" OR (strPDFavQuote) = "<br>" OR (strPDFavQuote) = "<br>" & vbCrLf Then 
%> 
nothing available
<%
Else
%> 
 
<br><h2>statement</h2><%=rs("PDFavQuote")%>
<%
End If
%>

Any help would be great.
Thanks
Richard

[fran7]

Hi, just to say I worked it out and this does the trick.

<% If Trim(rs("PDFavQuote")) = "" OR Trim(rs("PDFavQuote")) = "<P>&nbsp;</P>" OR Trim(rs("PDFavQuote")) = "<br>" OR Trim(rs("PDFavQuote")) = "<br>" & vbCrLf Then 
%> 
There is currently no statement
<%
Else
%> 
<%=rs("PDFavQuote")%>
<%
End If
%>

Thanks
Richard