Most likely you are looking for the real or float datatype. If you know you are always going to have 2 or fewer decimal places, you could also use the decimal datatype with a scale of 2.
----- Original Message ----- From: "Phillip Broussard" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 12:49 PM Subject: Im a doof! Help! > I don't want to look like an idiot on cf-talk so I will ask here. > > What datatype do you use in SQL server 2000 to store either 12345.12 or 6789? > > Some times I like to think I'm to smart to remember the smal yet sometimes important things like this. Or not. ;p > > Thanks Ya'll > > Phillip > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
