|
Posted by Jens on 09/13/05 12:28
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
---
Navigation:
[Reply to this message]
|