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-09-26 : 10:11:24
|
| Balaji writes "Hi,I am trying to write a query/function/stored procedure for retrieval in SQL Server2000. Please help me out with the query if you canI have a keyword passed as parameter to the query say "CUSTOMER" for the column named description.The query should try to search into this column of the table for CUSTOMER. If its found the resultset is returned. Else it would search for CUSTOME. If CUSTOME is found then its returned else the next pass searches for CUSTOM. the search continues till C is reached and if still its not found then "Not found message should be displayed.Would appreciate any help in this regards.Thanks" |
|
|
|
|
|
recursive query