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. - Hide quoted text - <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 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

Sql Server Programming

urgent