SQLDATASOURCE

[User 4501991]

Does anyone know how to convert a string to a double within the SELECT statement of a SqlDataSource? The data source is a SQL Server database and the values in the fields are all strings. The major problem is that in the Datalist, all of the leading zeros are displayed. Plus I do need to compute one item from three fields. Thanks for you help Gene :omg:

[Not Active]

Use Cast or Convert http://msdn2.microsoft.com/en-us/library/ms187928.aspx[^]

---

only two letters away from being an asset

[User 4501991]

Thanks for the response, but I get the error message "InCorrect Syntax" It changes CAST(D1.UNIT_RATE AS DECIMAL(10, 2)) AS Rate, to: [CAST](D1.UNIT_RATE AS [DECIMAL](10, 2)) AS Rate, I am working in Visual Web Developer and it seems that not all of the functionality of SQL Server is available. Gene