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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How do you do a SELECT Statement with a two word or more index?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-04 : 11:13:12
Michael writes "I am building a database of coins that includes the field "Category". Sample data for "Category" is Colonials, or Buffalo Nickels, or Entire Inventory. The Query only works with Colonials. The SELECT Query will not work if there is a space or 2 or more words in the field "Category". Is there a Java Script or ASP that removes the spaces before I do the query?"
   

- Advertisement -