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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-07-06 : 03:10:53
|
| Hi,PhoneBookIDfeed='20804291'This value which is a varchar(10) is present in tblPhoneBook but not in tblPhoneBookFeedSAPso why this query does not return this value?select PhoneBookIDfeed from tblPhoneBook where PhoneBookIDfeed not in (select PhoneBookIDfeed from tblPhoneBookFeedSAP)Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-06 : 03:17:26
|
| Trailing spaces on one of them?Kristen |
 |
|
|
raclede
Posting Yak Master
180 Posts |
Posted - 2005-07-06 : 03:48:37
|
select PhoneBookIDfeed from tblPhoneBook whereLTRIM(RTRIM(PhoneBookIDfeed)) not in (select LTRIM(RTRIM(PhoneBookIDfeed)) from tblPhoneBookFeedSAP)"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. " raclede |
|
|
|
|
|
|
select