Convert float into varchar in SQL Server without scientific notation

by

Casting or converting to VARCHAR(MAX) or anything else did not work for me using large integers (in float fields) such as 167382981, which always came out ‘1.67383e+008’.

What did work was STR().

More Related Contents:

  1. How to get the last row from a table in SQL Server?
  2. The order of a SQL Select statement without Order By clause
  3. Storing a file in a database as opposed to the file system?
  4. SQL Server named instance with Visual Studio 2017 Installer project
  5. Preferred Method of Storing Passwords In Database
  6. How do you count the number of occurrences of a certain substring in a SQL varchar?
  7. Why is it considered bad practice to use cursors in SQL Server?
  8. Import Excel spreadsheet columns into SQL Server database
  9. Find index of last occurrence of a sub-string using T-SQL
  10. Hidden Features of SQL Server
  11. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  12. SQL Server 2008 Empty String vs. Space
  13. How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
  14. SQL Query to find the last day of the month
  15. SQL Server, convert a named instance to default instance?
  16. How to drop column with constraint?
  17. How to specify a port number in SQL Server connection string?
  18. How do I search an SQL Server database for a string?
  19. WHERE clause on SQL Server “Text” data type
  20. SQL Server – parameter sniffing
  21. Does the order of columns in a WHERE clause matter?
  22. SQL Rows to Columns
  23. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  24. What is the best way to implement Polymorphic Association in SQL Server?
  25. Set option 9 in SQL Server stored procedure using WinHttp.WinHttpRequest.5.1 for TLS 1.2
  26. How to generate auto increment field in select query
  27. Get row where datetime column = today
  28. Full text catalog/index search for %book%
  29. Why insert-select to variable table from XML variable so slow?
  30. Slow query with cfqueryparam searching on indexed column containing hashes

Leave a Comment