I thought putting the integer value 500000 into a varchar(5) would result in a string with value '50000' (removed last 0). Now I learned it's resulting in a string with value '*'.
Thanks for letting me learn someting new...:w00t:
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **