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 |
|
acdacd
Yak Posting Veteran
63 Posts |
 Posted - 2005-08-26 : 03:34:38
|
| In query analysiser, i can write the condidtion as "where TabA.ColA like '%Good%' " or sth like that.But if two table col involved i find i cannot write " TabA.ColA like %TabB.ColB% "how to do this be a hardworking people!! |
|
|
LarsG
Constraint Violating Yak Guru
284 Posts |
Posted - 2005-08-26 : 03:55:38
|
| [code]TabA.ColA like '%' + TabB.ColB + '%'[/code] |
 |
|
|
|
|
|
like problem