Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nir_the_king
Starting Member
2 Posts |
 Posted - 2004-06-18 : 05:19:04
|
| [font=arial]before I ask you some questions i have some notes: 1. english isn't my language so I'm sorry if my message not clear :-) how I do a search query? I know about the wildcard but I want to do an Advanced Search in other words if i have this sentences : "the day after tomorrow" I want that the query search by word like the result of this query: SELECT fld FROM tbl WHERE txtField LIKE '*the*' OR txtField LIKE '*day*' OR txtField LIKE '*after*' OR txtField LIKE '*tomorrow*' How I do this with SP in MS ACCESS? thanks Nir [/font] |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-06-18 : 08:26:06
|
| If your Backend is MDB Your Fine.If your backend Is SQL Change your statement like this.SELECT fld FROM tbl WHERE txtField LIKE '%the%' OR txtField LIKE '%day%' OR txtField LIKE '%after%' OR txtField LIKE '%tomorrow%'JimUsers <> Logic |
 |
|
|
nir_the_king
Starting Member
2 Posts |
Posted - 2004-06-18 : 10:08:36
|
| You don't understand.I want that this query: "SELECT fld FROM tbl WHERE txtField LIKE '*the*' OR txtField LIKE '*day*' OR txtField LIKE '*after*' OR txtField LIKE '*tomorrow*' " will create automaticly. For example in google when I insert this sentence in the search input and click submit I get the results of the query that I show before. How I do this?Thanks Again Nir :-) |
|
|
|
|
|
|
searching query