SQL data Convertion

hi,

im using sql server as my backend and one filed has 00-1 (varchar) and want to conver to -1 (decimal).

how shd i implement this in SQL statement.

Take a look at the CAST and CONVERT functions in SQL Server...

Code:

---

SELECT CAST(MyTableCol AS decimal(10,5))

---