SQL Data type

What is the proper data type to get
NNNNNNNN

to 4 decimal places
Larry Bristersr. DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RehanYousafConnect With a Mentor Commented:
SELECT CONVERT(DECIMAL(12,4),10000)

BTW if you provide an example and desired result ... it will help
0
 
Scott PletcherConnect With a Mentor Senior DBACommented:
SELECT CAST(column_name AS decimal(12, 4))
FROM ...

or

SELECT CAST(hardcoded_value AS decimal(12, 4))
0
 
Larry Bristersr. DeveloperAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.