The CAST() should work. Can you post your table and view DDLs and error you get?

>
>I have an SQL database that is set up to store Latitude and Longitude in a Varchar field. I need to convert the Varchar to a float or decimal in a view. I am not having any luck using cast or convert to make the change can anyone suggest a way to make this happen? The data in the Varchar field looks like this 95.12345 for Latitude and -68.12345 for Longitude.
>