>Because both CONVERT() exceeds the defined length of the field.
>
>UPDATE ... SET ...
> GeographyTemporary='POINT('+CONVERT(CHAR(100),Longitude)+' '+CONVERT(CHAR(100),Latitude)+')'
>
>Will give you total length of 208 and the field is defined as CHAR(100).
Thanks, so basically, if I would want to use a Char field type, I would need to define it 208. When using Varchar(100), its maximum length is much greater than 100 then. Do you know what it is? Or, if I would wish to define it to a lower value, to support this, would there be a better field declaration than Varchar(100)?