How to convert float to varchar in SQL Server

by

Try using the STR() function.

SELECT STR(float_field, 25, 5)

STR() Function

Another note: this pads on the left with spaces. If this is a problem combine with LTRIM:

SELECT LTRIM(STR(float_field, 25, 5))

More Related Contents:

  1. SQL group_concat function in SQL Server [duplicate]
  2. Pivot Dynamic Columns, no Aggregation
  3. How to connect to local instance of SQL Server 2008 Express
  4. Export query result to .csv file in SQL Server 2008
  5. varchar(max) everywhere?
  6. T-SQL: Export to new Excel file
  7. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  8. SQL MERGE statement to update data
  9. How to get the last record per group in SQL
  10. How can I load a large flat file into a database table using SSIS?
  11. How to convert datetime in Persian in SQL Server
  12. How does sql server sort your data?
  13. How to restore to a different database in SQL Server?
  14. Why is SQL Server 2008 Management Studio Intellisense not working?
  15. Reporting Services permissions on SQL Server R2 SSRS
  16. T-SQL substring – separating first and last name
  17. SQL Server: Split operation
  18. How to implement polymorphic associations in an existing database
  19. How to get week number of the month from the date in sql server 2008
  20. How to deploy SQL Server Compact Edition 4.0?
  21. Restoring database from .mdf and .ldf files of SQL Server 2008
  22. What is the default transaction isolation level for SQL Server with ADO.NET?
  23. Restrict SQL Server Login access to only one database
  24. T-SQL strip all non-alpha and non-numeric characters
  25. How can I get a trigger to fire on each inserted row during an INSERT INTO Table (etc) SELECT * FROM Table2?
  26. Avoiding IF ELSE due to variable been NULL
  27. Where are SQL Server connection attempts logged?
  28. SQL Server 2008 Connection Error “No process is on the other end of the pipe”
  29. SSIS LookUp is not dealing with NULLs like the docs say it should
  30. Forcing code-first to always initialize a non-existent database?

Leave a Comment