conversion ?

#1

how can i converts a varchar to a smallmoney value

#2

Peter

SELECT convert(varchar,cast(22.2 as smallmoney),1)

SELECT convert(smallmoney,cast(22.2 as varchar(10)),1)

"Peter Newman" <PeterNewman (AT) discussions (DOT) microsoft.com> wrote

Quote:

how can i converts a varchar to a smallmoney value

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

conversion ?

microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming

conversion ? - 12-13-2004 , 06:31 AM

Re: conversion ? - 12-13-2004 , 06:38 AM