Re: TR: Like and =

Nicolas JOUANIN wrote:

>Hi,
>
> Thanks for your help. In fact that means 2 solutions for this:
>
>1) select * from pdi where rtrim(pdi) = '1006666058' 
>
>or
>
>2) Use VARCHAR instead of CHAR
>
>I don't which is the best , but both are working.
>
>Nicolas.
>  
>

Do you have a specific reason why to use CHAR?
I use CHAR only for certain one-byte flags, and even there its use is 
debatable.
I would use VARCHAR; if I was you.

Cheers,
Dani