Re: Query Problem

From: KIN Wong <kinwong_at_tdl.com.hk>
Date: 1998/01/23
Message-ID: <34C8059A.EDB@tdl.com.hk>#1/1

Sajal Kumar wrote:
>
> it is very possible that the fields that you are joining the two tables
> on do not have the same datatype. One may have the char(n) type which
> would keep the length of the value in that field n characters long
> although, the data itself may be less that n charc. long.
> thanx.
> sajal.

Hello Sajal Kumar

The datatype for these two fields are the same - Varchar(12) I have fixed that problem by backup this table and restore it. after restore it no longer required to rtrim the join fields

But up to now I still don't know why the query doesn't work before. thanks for you help

KIN. Received on Fri Jan 23 1998 - 00:00:00 CST