if fld.name "is like" futurefield

[charanch]

Hello to this great forum. I'm new here so please bear with me. I know about =, >, <, and <> but is there an operator for &quot;like&quot; in an IF statement, as there is in a SQL statement? Here's what I need:

I'm using:

for each fld in oRs.fields
if fld.name &quot;is like&quot; &quot;Futurefield&quot; then
'do something
end if
next

If that's not possible, what if anything can I do weed out the futurefields? Thank you very much for your thoughts!

 

[sharedworld]

use the instr function:

for each fld in oRs.fields
if instr(fld.name,&quot;Futurefield&quot then
'do something
end if
next

 

[charanch]

Thanks for that. I'll try it.

 

[foxbox]

First: the InStr function returns the numeric position of the first occurrence of a specified substring within a specified string when starting from the beginning (left end) of the string. So it does not return true or false, but an integer.

Second: i suppose you want to check if the contents of the field contains &quot;Futurefield&quot;. In the sample above the test is on the fieldname.

So change it to:

for each fld in oRs.fields
if instr( fld.value,&quot;Futurefield&quot > 0 then
'do something
end if
next

br
Gerard