<div>
&gt;&gt;I cannot get the LIKE clause to work with this if then statement. What am I doing wrong?&lt;&lt;<br />
That is because the Visual Basic Like operator is not supported in VBScript. &nbsp;See here for a complete list of the differences between Visual Basic and VbScript:<br />
<a href="http://msdn.microsoft.com/en-us/library/30593abb(VS.85).aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/30593abb(VS.85).aspx</a><br />
<br />

</div>


>>I cannot get the LIKE clause to work with this if then statement. What am I doing wrong?<<
That is because the Visual Basic Like operator is not supported in VBScript.  See here for a complete list of the differences between Visual Basic and VbScript:
http://msdn.microsoft.com/en-us/library/30593abb(VS.85).aspx [http://msdn.microsoft.com/en-us/library/30593abb(VS.85).aspx]



<div>
Just a minor correction to the previous workaround (no points please):<br />
<br />
If Instr(1, rstimes.Fields.Item(&quot;Prodo<wbr />ption&quot;).Va<wbr />lue,&quot;Tripl<wbr />e&quot;, vbTextCompare) = 1 Then<br />
&nbsp; &nbsp;varused = 3<br />
End If<br />
<br />
You should also be able to use RegEx for the same result.
</div>


Just a minor correction to the previous workaround (no points please):

If Instr(1, rstimes.Fields.Item("Prodoption").Value,"Triple", vbTextCompare) = 1 Then
   varused = 3
End If

You should also be able to use RegEx for the same result.

<div>
Thanks acperkins, I always forget that detail.
</div>


Thanks acperkins, I always forget that detail.

<div>
<div class="content wysiwyg-content">
Please see my code below. I cannot get the LIKE clause to work with this if then statement. What am I doing wrong?<br />
Thanks<br />

<pre><code id="code-311065">If (rstimes.Fields.Item(&quot;Prodoption&quot;).Value)  LIKE &quot;Triple%&quot; Then
varused = 3
end if
</code></pre>
</div>
</div>


Please see my code below. I cannot get the LIKE clause to work with this if then statement. What am I doing wrong?
Thanks

ASP If then using like

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.