Hi all!

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.

Thanks!

Jim Harvey