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] Thu, 30 Oct 2003 21:21:01 +0800
To: "LazyDBA.com Discussion" <[Email Address Removed] 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] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page