HanShi (10/6/2008)
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:
this was part of my thinking as well, that the value will just be truncated.....
hence i moved on to the following steps and anticipated the error further down the statement list.