Re: Weird Characters in table

["Raul A. Jager W." <raul@xxxxxxxxxx>]

DSPPFM has an option to show the HEX values, there you can find out if 
there are characters different form blank ( x'40' ) after your email addres.

Ashish Kulkarni wrote:

> Hi
> I am running into weird issue of having some weird characters in table
> which are not displayed on any SQL program, for example if i run query
>
> select * from mycontact where email  = 'myemail@xxxxxxxx'; this query does
> not return any rows, but if i modify the query like below
>
> select * from mycontact where email  *like 'myemail@xxxxxxxx%'*; it returns
> data, so i believe is there is some weird data after *.com *, but if i run
>
> select * from mycontact; from 5250 screen or iseries navigator i dont see
> any characters after .com, so how do i find what it is, and how do i fix
> this data
>
> Regards
>