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)
 SQL Statement that has begins with

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-30 : 13:50:29
Fayaz Rahimi writes "I am working on a ASP project that has a search page to it from the database. It goes to the database and searchs all the customer names and gives them back on the screen. Well right now I have the sql statement with a like '%' and it searches the whole string and returns all values that the character or letter that I am searching for anywhere on the field. Is there a way that I can limit it so it searches from the begining of a field?

Thank you"
   

- Advertisement -