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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-07 : 09:27:59
|
| Bart writes "I'm testing a search engine I wrote in ASP. The user enters a word and in the SQL Server 7 database these words are searched. My idea was to display these items in order of occurences. Say that in field 51 the word appears 25 times and in field 30 15 times, then I want to order this descending. So field 51 comes before field 30.But how can you do this?The count function returns me the number of rows where the occurence is found.The only function I see to get the occurences is the Replace function.Is there a way to count this????PS: I'm using SQL Server 7.0,Windows NT4 with sp4" |
|
|
|
|
|
Occurences in an SQL field