Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

urgent


i need the query for converting the integer into float or vice versa

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Check out CONVERT() and CAST() in the BOL.

--
   Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON   Canada
.

<tazeena farheen> wrote in message news:2007369656taz_far@yahoo.co.in...

i need the query for converting the integer into float or vice versa

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

-----------------------------------------------Reply-----------------------------------------------

look up CONVERT/CAST in BooksOnline.

On Mar 6, 8:12 am, "Immy" <therealasianb@hotmail.com> wrote:

> look up CONVERT/CAST in BooksOnline.

> <tazeena farheen> wrote in messagenews:2007369656taz_far@yahoo.co.in...
> >i need the query for converting the integer into float or vice versa

> > EggHeadCafe.com - .NET Developer Portal of Choice
> >http://www.eggheadcafe.com

You should be able to use something like:

cast(IntegerItem as float) or the other way could be
ceiling(FloatValue) (-or- floor(FloatValue)). Hope this helps.

Regards,

Enrique Martinez
Sr. SQL Server Developer

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc