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 |
|
marconi8
Yak Posting Veteran
73 Posts |
 Posted - 2003-05-05 : 07:02:28
|
| i have >10 full-text fields, clints on my web page in search page can choose searched fields, it is possible make contain condition with one contain statement likewhere CONTAINS([field_x,field_y,field_x1...field_x[i]],'"aa" or "bb" or "cc"') instead of CONTAINS(field_x,'"aa" or "bb" or "cc"') OR CONTAINS(field_y,'"aa" or "bb" or "cc"') OR CONTAINS(field_x1,'"aa" or "bb" or "cc"') |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-05 : 07:21:15
|
| As far as I know CONTAINS only allows one column or all the columns in a table which would be indicated by *.Too bad you can't define full-text indexing on a view. |
 |
|
|
marconi8
Yak Posting Veteran
73 Posts |
Posted - 2003-05-05 : 07:40:29
|
| also second bad thing is that i cannot use contains(field,"'a'")one chr is not possible, and i must to add to my sql build function one more check if string.length = 1 then field name like array[i] this all small checks slows speed, :( hm maybe some gurus has successfuly solved problem for contains using one chr ? |
|
|
|
|
|
|
field list instead one field or * chr in CONTAINS