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 |
|
ross.fraser
Starting Member
1 Post |
 Posted - 2008-11-07 : 00:13:52
|
| Hi guysI am having a problem with the NEAR statement.select where contains... ("red" and "blue" near() "green") works perfectly, however a more complex query as below:select where contains ('("red" and "blue") or ("green") near "purple" ') gives Incorrect syntax near 'NEAR'Please tell me why NEAR doesn't like being next to brackets ()ThanksRoss |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-07 : 01:26:22
|
select where contains ('("red" and "blue" or "green") near() "purple" ') gives Incorrect syntax near 'NEAR'
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Problem with Near()