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 |
|
shaileshk
Starting Member
6 Posts |
 Posted - 2008-04-03 : 08:28:05
|
| Hello All,I would like to know how to search organisation from the Organisation table I run the Query as below SELECT *FROM orgWHERE (organisationname LIKE 'del%')Search Reult for the Above Query is thisDEL BOY'S DELTA Computer DELUXE DESIGNS LTD DELYTH AT TONY'S DELYN HIRE CENTRES LTD DELUXE LABORATORIES LTD DELVER CONSTRUCTION DELWYN PARKER DELYN HIRE CENTRES LTD When i search with SELECT *FROM orgWHERE (organisationname LIKE '%del%')The DEL ComputerDEL BOY'S DELTA Computer DELUXE DESIGNS LTD DELYTH AT TONY'S DELYN HIRE CENTRES LTD DELUXE LABORATORIES LTD DELVER CONSTRUCTION DELWYN PARKER DELYN HIRE CENTRES LTD But i need search result with match whole ('del')word with the oragatiosation recordsi.e.The DEL ComputerDEL BOY'S Thanks Shaileshshailesh kavathiyahttp://www.codegroup.com/blog/ |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-04-03 : 08:32:00
|
| like '%del %' ?Em |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-03 : 08:33:25
|
| [code]organisationname Like 'DEL %' or organisationname Like '% DEL %'[/code]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-04-03 : 08:35:50
|
was just coming back to correct that  Em |
|
|
|
shaileshk
Starting Member
6 Posts |
Posted - 2008-04-03 : 09:20:20
|
| It's realy helpful to me..Thanks a lot both of you.Shailesh Kavathiyahttp://www.codegroup.com/blog/ |
|
|
|
|
|
|
Search Organisation name