Double should do the trick.. See the Chart at the link below
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vben...
ml/vagrpDataType.asp?frame=true
Scot
--------------------
Quote:
>Newsgroups: microsoft.public.vb.enterprise
>Subject: SQL Server Decimal type
>X-Newsreader: Forte Free Agent 1.21/32.243
>Lines: 4
>Date: Fri, 03 Aug 2001 04:09:38 GMT
>NNTP-Posting-Host: 24.100.181.125
>X-Trace: news3.rdc2.on.home.com 996811778 24.100.181.125 (Thu, 02 Aug 2001
21:09:38 PDT)
>NNTP-Posting-Date: Thu, 02 Aug 2001 21:09:38 PDT
>Path:
cppssbbsa01.microsoft.com!tkmsftngp01!newsfeed00.sul.t-online.de!t-online.d
e
!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newshub2.home.com!news.home
.com!news3.rdc2.on.home.com.POSTED!not-for-mail
Quote:
>Xref: cppssbbsa01.microsoft.com microsoft.public.vb.enterprise:61111
>X-Tomcat-NG: microsoft.public.vb.enterprise
>Is there any data type in VB, other than variant, can be use to hold a
>SQL Server DECIMAL(28,0) value?
>Thanks in advance!