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
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
select * from table WHERE field LIKE "%ill%"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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.
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.