access sql find function

[futurevc]

Hi

I'm writing a simple access sql (actually in coldfusion)
I need the access sql function for finding a substring
e.g. if the database field is myname and I want to pull up records which contain the characters "bob" then Im guessing i need something like

select *
from
where find(myname,'bob')>0

incidentally is there a good list of access sql scalar functions anywhere cant find anything from google

Thanks

Tim

 

[cmmrfrds]

instr definition.

Function InStr([Start], [String1], [String2], [Compare As VbCompareMethod = vbBinaryCompare])

instr(myname,'bob')>0

 

[PHV]

Try this:
WHERE myname Like '*bob*'
or this:
WHERE myname Like '%bob%'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886