CFIF variable wild 1

[KOVMoe]

I have an applicaiton where i need to search for a certain word in a string. So I just do a CFIF tag like this:

<cfif #qryData1.CustomerName# like '%Hold%'>
<cfset a = 104>
<cfelse>
<cfset a = 10402>
</cfif>

Will the place holder % work?

Thank you,

Moe-King of the Village Idiots.

"When in trouble,
when in doubt;
Run in circles-
SCREAM & SHOUT!!"
Burma Shave

 

[FALCONSEYE]

<cfif qryData1.CustomerName CONTAINS 'Hold'>
...


hope it helps

http://www.jetansolutions.com

 

[KOVMoe]

CONTAINS is exactly what I was looking for, Thanks!!!!!

Thank you,

Moe-King of the Village Idiots.

"When in trouble,
when in doubt;
Run in circles-
SCREAM & SHOUT!!"
Burma Shave

 

[FALCONSEYE]

you're welcome...

http://www.jetansolutions.com