Posted by himani on 09/13/05 14:03

hi Jens,
thanks for ur suggestion.

Jens wrote:
> it impplicit cast the value to an integer. An integer with a trailing 0
> isn´a integer, because this is a string. So you should store that as a
> char / varchar type to presume that information (same here in germany
> after the redesign of the zip code which afterwards contained trailing
> zeros)
>
> HTH, jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---

[Back to original message]