Skip to content

Instantly share code, notes, and snippets.

@b2977053

b2977053/string_function_STR.sql

Created December 14, 2019 04:15
Show Gist options
  • Save b2977053/d653a483fb9493fc85f0603eac85cec4 to your computer and use it in GitHub Desktop.
Save b2977053/d653a483fb9493fc85f0603eac85cec4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
string_function_STR.sql
DECLARE @f FLOAT, @d MONEY, @i INT
SET @f = 1234567890.12
SET @d = 1234567890.12
SET @i = 1234567890
SELECT @f, CONVERT(varchar, @f), '-'+STR(@f,13, 2)+'-'
SELECT @d, CONVERT(varchar, @d), '-'+STR(@d,13, 2)+'-'
SELECT @i, CONVERT(varchar, @i), '-'+STR(@i,13, 2)+'-'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment