Converting Varchar to Float in SQL Server

NVARCHAR OR VARCHAR TO FLOAT IN SQL SERVER:

For converting the data from one datatype to another, you need to use CONVERT function.

The syntax is CONVERT(DATATYPE,COLUMN NAME)

SAMPLE QUERY:

CREATE TABLE VENKAT_TAB (ID INT, VAL nVARCHAR(100))

INSERT INTO VENKAT_TAB VALUES (1,'10.453425345')

SELECT ID, CONVERT(FLOAT,VAL) AS FLOATVAL FROM VENKAT_TAB

Cheers,
Venkatesan Prabu. J