Link to home
Start Free TrialLog in
Avatar of CiaranG
CiaranG

asked on

select * from table WHERE field CONTAINS "ill" - missing parameter

I am using the following statement to search for a field that contains some data
select * from table WHERE field CONTAINS "ill"

in a field that contains names such as
will
bill
john
ted

thsi should returns the records will & bill
this is giving me a message saying that there is a parameter missing
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

select * from table WHERE field LIKE "%ill%"
ASKER CERTIFIED SOLUTION
Avatar of appari
appari
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CiaranG
CiaranG

ASKER

appari when I run your query I get the following
Syntax Error (missing operator) in query expression 'CONTAINS (ContactName, "time")'

why is this ?

angellll - this works - cheers - but what does the LIKE do - if I want to use wild cards can I used the like command
"f I want to use wild cards can I used the like command"

The % characters in the LIKE command are wildcards:

To get everything that ends with ill:  select * from table WHERE field LIKE "%ill"
To get everything that begins with ill:  select * from table WHERE field LIKE "ill%"

etc. etc.