Like, it's not finding it. 3

[tlhawkins]

Hey guys,

I have a search form that I want to be able to find parts of words.

If my field contains "California" I want "ca" to produce a hit.

I thought "Like" would do it but apparently no.
Is there anyway to use a real expression search with SQL?

Thanks in advance

 

[CDN]

[tt]Like% should do the trick

 

[JohnYingling]

Like is not in VBScript. Use Instr.
lngInstr = Instr(1,strW,"ca",1) ' 1 for case insensitive.
if lngInstr > 0 then
...found
End If

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[onpnt]

johnYingling is correct. LIKE is not at ALL supported in VBscript as with many other comparison operators. This sounds like a good FAQ thread. check this thread for a example of using the Instr which is the way around using LIKE.
thread329-291077 I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.

 

[onpnt]

JohnYingling a star for pointing this comparison differnce in Vbscript and VB out. I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.

 

[lonelybug]

please who me your code!

 

[sera]

This is very annoying! Why would like be unsupported?
What a frustrating problem!
Sera