In report builder, you may want the function TRUNC instead. Again, though, you will find all of this in BOL.

Books On-Line should be your next best friend (with SSC...

Have you looked up the ROUND() function in BOL yet? I'm pretty sure that this may help you solve your problem.

Alvin Ramard (5/20/2009)

Luke L (5/20/2009)

Alvin Ramard (5/20/2009)

Jack Corbett (5/20/2009)

I have to admit being disappointed you didn't...

Jack Corbett (5/20/2009)

I have to admit being disappointed you didn't say something like:

"Use the force well...

Jack Corbett (5/20/2009)

I have to admit being disappointed you didn't say something like:

"Use the force well...

Examples:

select 1.AColumn :

AColumn

---------

1

select 1.0AColumn :

AColumn

---------

1.0

Now do those with a space before AColumn, you will get the same results.

Now, for those of you waiting impatiently for the explaination, here it is.

SELECT 1.Acolumn is equivalent to SELECT 1. Acolumn. (there is a space between the . (dot) and...

YEA!!!! I Figured it out with a little help from a co-worker!!!!!

Try this and look at the table created:

SELECT

30.AString

,50.AnotherString

,10.SomethingElse

into dbo.TempTable;

select * from dbo.TempTable;

That is interesting. I have no explanation.

Thanks Luke!

Pardon the "Let Me Google That For You", but here are some places for you to start your research:

Google Search of SSC

Thanks, Lowell. I have passed it on to one of our developers to research.

Would someone who knows SSRS please go help this person?

You are welcome.