Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Item Avg Unit Price numeric(18,4)

Home
Forums

Item Avg Unit Price numeric(18,4)

Basit Khan

9yAsked Dec 6, 2016, 11:17 AM1.2k

Hi,

I have Item Master the fields are

Itm_No numeric(18, 0)

Itm_Code nvarchar(50)

Itm_Desc nvarchar(500)

Itm_UnitPrice numeric(18, 4)

the data's are

1	00001111	HP Laptop	14.3310
2	00001112	Dell Laptop	14.3541
3	00001113	samsung	14.1000

what i want only take the exact decimal place.

1	00001111	HP Laptop	14.331
2	00001112	Dell Laptop	14.3541
3	00001113	samsung	14.1

Thanks

Basit.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Basit Khan9y ago
Is float is only one option?

Thanks
Basit.
Nilesh Shah9y ago
in SQL, declaring a field as numeric(18, 4) means it stores 4 digits precision after decimal point.

If you want to show the decimal fraction without trailing zeros, then you can cast the value to float.

run this query in SQL and you will get your answer:

select
cast(123.4000 as numeric(18,4)) as 'Numeric Format',
cast(cast(123.4000 as numeric(18,4)) as float) as 'Float Format'

here is the answer: