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 |
|
smile
Starting Member
22 Posts |
 Posted - 2009-04-10 : 14:52:11
|
| Hello!How can I mark that for example - the companyname contains the name of the suppliername? I mean that in this case the pattern contains some already known string like 'abc'. Here the contained string is not known but it's something like parameter...? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
smile
Starting Member
22 Posts |
Posted - 2009-04-10 : 15:38:19
|
| Ok...here's an example query: retrieve all the names of companies from the table Suppliers(Companyname,Suppliername), that contain in their names a name of a supplier. e.g. The company "Tomaty" contains the name of the supplier "Tom" |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
smile
Starting Member
22 Posts |
Posted - 2009-04-10 : 16:37:39
|
| Ah...yeah...I should have guessed it :) Thanks a lot! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
about "like" and patterns