Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by heyvaers
-
convert char into float
Maybe I don't understand the real problem, but SQL server knows the CONVERT() function. In your example, this would give : SELECT CONVERT(float,'0.8333') You can test this in the query analyser. And for Access 2000, you can use cdbl("0.8333") to get a float from the string. Only thing...- heyvaers
- Post #2
- Forum: Microsoft SQL Server: Programming
