Thursday, September 09, 2010 Register
XLeratorDB/convert Documentation
Home
XLeratorDB/conversions

Use XLeratorDB/conversions for a wide variety of unit conversion calculations. The feature-rich XLeratorDB function library lets you include calculations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns.

XLeratorDB/conversions requires Microsoft  SQL Server®  2005 or later (which must be purchased separately). XLeratorDB/conversions installs in minutes and can be used immediately after installation. Anyone familiar with the functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB/conversions.

For more information see the blog post discussing XLeratorDB/conversions.

FUNCTION REFERENCE - CONVERSION FUNCTIONS
AREA
CONVERTAREA Area unit conversions
ACRES Convert area to Acres
HECTARES Convert area to Hectares
SQINCHES Convert area to Square Inches
SQFEET Convert area to Square Feet
SQYARDS Convert area to Square Yards
SQMILES Convert area to Square Miles
SQMETERS Convert area to Square Meters
   
LENGTH
CONVERTLENGTH Length Unit Conversions
INCHES Convert length to Inches
FEET Convert length to Feet
YARDS Convert length to Yards
METERS Convert length to Meters
MILES Convert length to Miles
NMILES Convert length to Nautical Miles
FATHOMS Convert length to Fathoms
FURLONGS Convert length to Furlongs
PICA Convert length to Picas
POINTS Convert length to Points
   
SPEED
CONVERTSPEED Speed Unit Conversions
INSEC Convert speed to Inches per Second
FTSEC Convert speed to Feet per Second
FTMIN Convert speed to Feet per Minute
FTHR Convert speed to Feet per Hour
MIHR Convert speed to Miles per Hour
MSEC Convert speed to Meters per Second
MMIN Convert speed to Meters per Minute
MHR Convert speed to Meters per Hour
KMHR Convert speed to Kilometers per Hour
MISEC Convert speed to Miles per Second
MIMIN Convert speed to Miles per Minute
MIHR Convert speed to Miles per Hour
KNOTS Convert speed to Knots
   
TEMPERATURE
CONVERTTEMP Temperature Unit Conversions
CELSIUS Convert temperature to Celsius
FAHRENHEIT Convert temperature to Fahrenheit
KELVIN Convert temperature to Kelvin
RANKINE Convert temperature to Rankine
   
VOLUME
CONVERT VOLUME Volume Unit Conversions
CUINCHES Convert volume to Cubic Inches
CUFEET Convert volume to Cubic Feet
CUYARDS Convert volume to Cubic Yards
CUMETERS Convert volume to Cubic Meters
CUMILES Convert volume to Cubic Miles
FLDRAMS Convert volume to Fluid Drams
FLOUNCES Convert volume to Fluid Ounces
TEASPOONS Convert volume to Teaspoons
TABLESPOONS Convert volume to Tablespoons
CUPS Convert volume to Cups
PINTS Convert volume to Pints
QUARTS Convert volume to Quarts
GALLONS Convert volume to Gallons
LITERS Convert volume to Liters
IMPOUNCES Convert volume to Imperial Ounces
IMPPINTS Convert volume to Imperial Pints
IMPQUARTS Convert volume to Imperial Quarts
IMPGALLONS Convert volume to Imperial Gallons
IMPGILLS Convert volume to Imperial Gills
BARRELS Convert volume to Barrels
BBLS Convert volume to US Beer Barrels
BUSHELS Convert volume to Bushels
GILLS Convert volume to Gills
PECKS Convert volume to Pecks
DRYPINTS Convert volume to Dry Pints
DRYQUARTS Convert volume to Dry Quarts
STERES Convert volume to Steres
   
WEIGHT
CONVERTWEIGHT Weight Unit Conversions
OUNCES Convert weight to Ounces
GRAINS Convert weight to Grains
DRAMS Convert weight to Drams
POUNDS Convert weight to Pounds
STONES Convert weight to Stones
CWT Convert weight to Hundred Weight
TON Convert weight to Tons
DWT Convert weight to Pennyweight
TROY Convert weight to Troy Ounces
TPOUNDS Convert weight to Troy Pounds
GRAMS Convert weight to Grams
TONNES Convert weight to Tonnes
   
   
 XLDB_CONVERT_VERSION Version Information



 |  View Topic History  |
Print  
Privacy StatementTerms Of UseCopyright 2010 WestClinTech LLC

BorderBoxedGrayBoxedGreenBlue Small width layoutMedium width layoutMaximum width layoutMaximum textMedium textSmall textBack Top!