Re: Problem querying a view

On Jun 11, 3:03 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Jun 11, 1:53 pm, teresa <pixelm..._at_gmail.com> wrote:
> > On Jun 11, 2:44 pm, teresa <pixelm..._at_gmail.com> wrote:

<lawnmower>

> You likely have trailing spaces on the USER_ID values and, as such,
> nothing is equal to your 'truncated' string. Try this and see what is
> returned:
>
> select '||user_id||' user_id
> from
> (select distinct user_id from ta);
>
> You may be surprised at what you find.
>
> David Fitzjarrell-

Once again you have saved the day. I am now getting the results I expected. Thank you so much!
teresa Received on Mon Jun 11 2007 - 14:31:12 CDT