你得用split对你所输入的进行分割来判断是否有空格，然后再进行查找。

+,-符号的判断不是sql自己的功能,而是需要自己编代码来做这样的逻辑判断的.

你可以参考一下split的用法.


另外,自己把自己的后面两个帖子删了,被斑竹删就不好了

好了，我就问一个问题!!!
(语法: array split(string pattern, string string, int [limit])
加在什么地方，怎么加，用什么加？
谢谢 ！！

可不可以用
if _____ then
strSearch="一 二 三 四"
arrSearch = split(strSearch," ") '////返回的arrSearch为一个数组
For i=0 to Ubound(arrSearch-1)
Response.Write(arrSearch(i)&"
")
Next
else
_________
endif

????可以吗?可以的话帮我填一下吧!我很皮厚吧!如果实在不行我只能叫人家不准输入空格了

The basic syntax for the split command is: split(string,delimiter).

Lets say for example you had a sentence "I Love fish they taste real nice" and you wanted to split the text into individual words and write them out on separate lines like this:

I
Love
fish
they
taste
real
nice

In this case the delimiter you want to use to split the string up would be a space, so your code would look something like this:

'Populate a variable with the sentence
strText = "I Love fish they taste real nice"

'Split the sentence into an array
arrTemp = split(strText," ")

'Loop through the array and write out the words on separate lines
For i = 0 to UBOUND(arrTemp)
response.write arrTemp(i) & "
"
Next


Wow, I hear you cray, very useful but whats it good for? I've found loads of uses for it, but by far the best is for performing searches, lets say we have a free entry text box in which users can enter several keywords separated by commas and the search is looking for ALL the words rather than an exact phrase. This is where the split command comes into its own. Lets say our search box is called "searchtext" and we want to build a SQL query that we can use to open a recordset that looks for all the words in a column called "Keywords" in a table called "SearchTable". The code might look something like this:

'Get the keywords from the form and split them into an array, using the commas as a delimiter
strText = Request.Form("searchtext")
arrSearch = split(strText,",")

'Build the basic part of the search query (the select statement)
strSQL = "select * from SearchTable"

'Loop through the array and add the keywords to the statement
For i = 0 to UBOUND(arrSearch)
If i = 0 Then
'this is the first item in the array, so include the where statement
strSQL = strSQL & " where Keywords like '%" & arrSearch(i) & %'"
Else
'This is not the first item, so include an and at the beginning
strSQL = strSQL & " and Keywords like '%" & arrSearch(i) & %'"
End If
Next


If we were using this properly we'd have checks to make sure they'd entered keywords and the like, but you can see how nifty the split command is.
我真的加了可是没有用呀！
Textsplit(string,delimiter).