Show if database field contains text

Hello,

I am working on a web site in ASP. I want to show a portion of the
page if the databse field contains a certain word. I know how to
display something if the field is empty or not empty, but I want to
display something if the field contains the word "none" anywhere in
the body of text.

Here's the code I'm trying. I thought I could use the LIKE command,
but to no avail:

<% if Recordset1.Fields.Item("strEduMaterials").Value LIKE "none" then
%>


Any suggestions?

Thanks!

Randy

On 19 Nov 2004 18:52:39 -0800, in macromedia.dreamweaver
randy (AT) mindson (DOT) com (RJames) wrote:

| Hello,
|
| I am working on a web site in ASP. I want to show a portion of the
| page if the databse field contains a certain word. I know how to
| display something if the field is empty or not empty, but I want to
| display something if the field contains the word "none" anywhere in
| the body of text.
|
| Here's the code I'm trying. I thought I could use the LIKE command,
| but to no avail:
|
| <% if Recordset1.Fields.Item("strEduMaterials").Value LIKE "none" then
| %

What database are you using?

Mysql etc:
<% if Rs.Fields.Item("strEduMaterials").Value LIKE % 'none' % then
%>

MsAccess:
<% if Rs.Fields.Item("strEduMaterials").Value LIKE * 'none' * then
%>

---------------------------------------------------------------
jnorth (AT) yourpantsbigpond (DOT) net.au : Remove your pants to reply
---------------------------------------------------------------