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 |
|
SQL_Rookie
Starting Member
32 Posts |
 Posted - 2009-05-06 : 13:15:40
|
| I have 2 tables with a string column ...say name and I want to find matches were both the names are a like or have part of one name n the other name column like...TableA TableBBob Who is BobJill Jill is over thereJane Jane SmithI want to find all the TableB records that "Contain" the TableA string? |
|
|
whitefang
Enterprise-Level Plonker Who's Not Wrong
272 Posts |
Posted - 2009-05-06 : 13:24:36
|
| SELECT * FROM [tableb] b, [tablea] a WHERE b.[column] LIKE '%' + a.[column]; |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-06 : 13:55:46
|
Or use proper CROSS JOIN instead of old syntax?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
help with finding strings...