formatting data 1

[myvision69]

i have a decimal number stored but i want to display the whole number only with three digits and no decimal places.

how can i do that in SQL?

Thanks

 

[gmmastros]

SQL has a round function, or you could convert it to another decimal(but with a different precision).

Declare @Temp Decimal(10,5)

Set @Temp = 123.75678

Select @Temp, Round(@Temp, 0), Convert(decimal(10,0), @Temp)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[myvision69]

e.g. 78.00 needs to be displayed as 078
1.00 needs to be dispayed as 001
150.00 needs to be displayed as 150

How can I accomplish that?

 

[vongrunt]

If you have to...

See CONVERT() and ROUND() functions in Books Online.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[vongrunt]

Quick & dirty trick:

select right(convert(decimal(4, 0), 1000 + yourvaluehere), 3)

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]