Home » SQL & PL/SQL » SQL & PL/SQL » varchar2(6) vs. varchar(12)
varchar2(6) vs. varchar(12) [message #21531] Fri, 09 August 2002 14:24 Go to next message
Susan
Messages: 102
Registered: October 2001
Senior Member
I have 2 tables that each have columns for master_ids. One table has a datatype of varchar2(6) for master_id and the other has a datatype of varchar2(12). I can't seem to match up the master_id as a join.

SELECT a.MASTER_ID
FROM TALK.MAST_PATI_DATA a, talk.LOC_PATI_PART_VIEW LP
WHERE a.master_id = LP.master_id

returns no rows, but I know there are matching ids. I tried converting the master_id to string and using rtrim but that didn't work either. Any thougts? Thanks. (another clue is that in the loc_pati_view the datatype was altered it was originally char6) Thanks.

Report message to a moderator

Re: varchar2(6) vs. varchar(12) [message #21533 is a reply to message #21531] Fri, 09 August 2002 14:32 Go to previous message
TomazZ
Messages: 7
Registered: August 2002
Junior Member
try:
where a.master_id = rtrim(LP.master_id)

Report message to a moderator

Previous Topic: Number of days in a year
Next Topic: Triggers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 06:31:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.