SQL Statement
I have the following SQL statement to pull in data from a database.
INVMASTER.StockCode and INVMASTER.ShelfLife are both strings. How do I change each field from a string to a number in the SQL code, so that it comes into the spreadsheet as a number instead of a string? SELECT INVMASTER.StockCode, INVMASTER.ShelfLife FROM dbo.INVMASTER INVMASTER |
SQL Statement
Hi TIML,
If you're using SQL Server, you can use the CAST statement: SELECT CAST(INVMASTER.StockCode AS Decimal(19,8)), CAST(INVMASTER.ShelfLife AS Decimal(19,8)) ..... You can use Float, Integer, etc, if you wish. Also look at CONVERT, as it has similar functionality. If you have SQL Server Books Online, that'd be a good place to look. If not, they can be found in MSDN somewhere. -- Regards, Jake Marx www.longhead.com [please keep replies in the newsgroup - email address unmonitored] TIML wrote: I have the following SQL statement to pull in data from a database. INVMASTER.StockCode and INVMASTER.ShelfLife are both strings. How do I change each field from a string to a number in the SQL code, so that it comes into the spreadsheet as a number instead of a string? SELECT INVMASTER.StockCode, INVMASTER.ShelfLife FROM dbo.INVMASTER INVMASTER |
SQL Statement
Hi,
You can use VAL(fieldname) function. -- Regards Haldun Alay To e-mail me, please remove AT and DOT from my e-mail address. "TIML" , iletide şunu yazdı ... I have the following SQL statement to pull in data from a database. INVMASTER.StockCode and INVMASTER.ShelfLife are both strings. How do I change each field from a string to a number in the SQL code, so that it comes into the spreadsheet as a number instead of a string? SELECT INVMASTER.StockCode, INVMASTER.ShelfLife FROM dbo.INVMASTER INVMASTER |
All times are GMT +1. The time now is 02:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com