Not round value

Question

Post reply

Not round value

Bruna

SSC Journeyman

Points: 87
More actions
November 8, 2005 at 1:42 pm

#166200

Hi People,
I have values like this:
125,4587878
1,369888
15487,9887
I just need two numbers after ',', but I dont want round the value.
125,45
1,36
15487,98
Please, help me..
Thanks

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Sql Junkie-204042 Hall of Fame Points: 3874 More actions · Answer 1

SELECT CASE WHEN CHARINDEX(',', @value) > 0 THEN LEFT(@value,CHARINDEX(',', @value)+2) ELSE @value END

Sergiy SSC Guru Points: 110208 More actions · Answer 2

It's recommended to open BOL time to time (press F1)

C. Use ROUND to truncate

This example uses two SELECT statements to demonstrate the difference between rounding and truncation. The first statement rounds the result. The second statement truncates the result.

Statement Result

SELECT ROUND(150.75, 0)

151.00

SELECT ROUND(150.75, 0, 1)

150.00

In your case : ROUND(Value, 2, 1)

_____________
Code for TallyGenerator

Wayne Lawton Hall of Fame Points: 3532 More actions · Answer 3

G'Day,

DECLARE @TestString VARCHAR (25),

@TestNum DECIMAL(20,10)

SET @TestNum = 125.4587878

SET @TestString = CAST(@TestNum AS VARCHAR)

SELECT @TestString, LEFT(@TestString,CHARINDEX('.',@TestString)+2)

SET @TestNum = 1.369888

SET @TestString = CAST(@TestNum AS VARCHAR)

SELECT @TestString, LEFT(@TestString,CHARINDEX('.',@TestString)+2)

SET @TestNum = 15487.9887

SET @TestString = CAST(@TestNum AS VARCHAR)

SELECT @TestString, LEFT(@TestString,CHARINDEX('.',@TestString)+2)

Hope this helps

Wayne

Bruna SSC Journeyman Points: 87 More actions · Answer 4

Bruna

SSC Journeyman

Points: 87

November 8, 2005 at 2:07 pm

#602886

Thanks a lot 🙂

Sergiy SSC Guru Points: 110208 More actions · Answer 5

For some reason people prefer to use slow and not reliable (locale dependable - will not work with $12,050.25) solutions and ignore proper ones.

_____________
Code for TallyGenerator

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Ninja's_RGR'us

SSC Guru

Points: 294069

November 9, 2005 at 9:10 am

#603049

Why do you think I don't hang out here anymore?!?!

ron k SSCertifiable Points: 6103 More actions · Answer 7

ron k

SSCertifiable

Points: 6103

November 9, 2005 at 11:53 am

#603091

Oh no, Remi say it isn't so.

ron k SSCertifiable Points: 6103 More actions · Answer 8

Ten years ago I don't think the truncate feature exisited (sysbase). I gave up looking. Sergiy, thanks so much for posting. I wonder how long the truncate feature has been there?

Thanks again,

ron

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 9

Check my recent post count if you need a confirmation .