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 - 2002-01-20 : 17:34:31
|
| Nawar writes "Dear Sir/Madam:I want to select a record that contain some word.SELECT * FROM table where keySearch like '%sql%' ;This statement retunn to me such field contains:"sqlmno, gjlkk"but I want to select the exact word or phrase which might be seperated from others by a space or a column",".Thank you very much for your helpBest regardsNawar" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-01-20 : 18:16:53
|
| Nawar Is this what you want?SELECT * FROM table where keySearch like '%[ ,]sql[ ,]%'I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Search text field