Divide / multiply (you don't specify in which direction) by 100?

> -----Original Message-----
> From: [Email Address Removed] [SMTP:[Email Address Removed] Sent: Thursday, October 30, 2003 2:43 PM
> To: LazyDBA.com Discussion
> Subject: RE: DPV(Distributed partitioned Views)
>
> I have a number that I want to move the decimal place, any ideas how I can
> move it two places.
> Any functions that will help do that. I have a tried a few things mainly
> converting to a string,
> and then convert back to a numeric, but I am running into trouble when I
> try to convert a negative value
> back to a number. In Oracle you can use the to_number function for most
> things. SQL Server, not
> available.
>
> Any Suggestions
>
>
>
>
> -----Original Message-----
> From: "Chris Kempster" <[Email Address Removed] Sent: Thu, 30 Oct 2003 21:21:01 +0800
> To: "LazyDBA.com Discussion" <[Email Address Removed] Subject: RE: DPV(Distributed partitioned Views)
>
> Hi there
>
> Please see my sample chapter on High Availability for some information
> related to this.
>
> www.chriskempster.com
>
> Any questions? Post them though :)
>
> Cheers
>
> Ck
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed] Hermes is the world's premier credit insurer, offering solutions for
the management of trade receivables, from credit insurance and factoring to
bonding and guarantees.

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient or have received this e-mail in error, notify
the sender immediately and destroy this e-mail. Any unauthorized use,
copying, disclosure or distribution of the contents of this e-mail is
strictly forbidden and may be unlawful.

Read our full e-mail disclaimer statement and monitoring policy
(http://www.eulerhermes.com/disclaim/email.cfm) before taking any action
based on the contents of this e-mail.
MS Sql Server LazyDBA home page