Skip to content

Instantly share code, notes, and snippets.

@fernandezja

fernandezja/sqlserver-convert-float-to-string-varchar.md

Last active December 14, 2021 11:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fernandezja/aad28c3285bee03429f6d8cd1f695783 to your computer and use it in GitHub Desktop.
Save fernandezja/aad28c3285bee03429f6d8cd1f695783 to your computer and use it in GitHub Desktop.
Download ZIP
Convert float to string/varchar #sqlserver #float #string #varchar
Raw
sqlserver-convert-float-to-string-varchar.md

[SQLServer] Convert Float To String/Varchar

-----------------------------------------------------------
-- Convert Float To String/Varchar
-----------------------------------------------------------
DECLARE @FloatValue FLOAT = -58.3921465762225

SELECT 
	OriginalValue = @FloatValue,
	ConverToStringVarchar1 = CONVERT(VARCHAR(50), @FloatValue),
	ConverToStringVarchar2 = CONVERT(VARCHAR(50), @FloatValue,128),
	ConvertToStringWithSTRFunction = STR(@FloatValue, 25, 13)

Results

OriginalValue ConverToStringVarchar1 ConverToStringVarchar2 ConvertToStringWithSTRFunction
-58,3921465762225 -58.3921 -58.3921465762225 -58.3921465762225
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment