How to suppress ".00" at the end of my datas in a column???

Hi everybody, here is my problem.

I have an entire column containing numeric data like "299.00". I have
to suppress the ".00" at the end. As I have approximately 2000 rows
I'd be glad if you could help me...

Thank you...

"Mayoutze" <jonathan.maier@gmail.com> schreef in bericht
news:1170250305.550141.27000@a75g2000cwd.googlegro ups.com...
> Hi everybody, here is my problem.
>
> I have an entire column containing numeric data like "299.00". I have
> to suppress the ".00" at the end. As I have approximately 2000 rows
> I'd be glad if you could help me...
>
> Thank you...
>

read the page at:
http://ww.mysql.com/doc/refman/4.1/e...functions.html

On 31 Jan, 13:31, "Mayoutze" <jonathan.ma...@gmail.com> wrote:
> Hi everybody, here is my problem.
>
> I have an entire column containing numeric data like "299.00". I have
> to suppress the ".00" at the end. As I have approximately 2000 rows
> I'd be glad if you could help me...
>
> Thank you...

What is the datatype of the field?

On Jan 31, 2:43 pm, "Captain Paralytic" <paul_laut...@yahoo.com>
wrote:
> On 31 Jan, 13:31, "Mayoutze" <jonathan.ma...@gmail.com> wrote:
>
> > Hi everybody, here is my problem.
>
> > I have an entire column containing numeric data like "299.00". I have
> > to suppress the ".00" at the end. As I have approximately 2000 rows
> > I'd be glad if you could help me...
>
> > Thank you...
>
> What is the datatype of the field?

the datatype is decimal...

On 31 Jan, 14:56, "Mayoutze" <jonathan.ma...@gmail.com> wrote:
> On Jan 31, 2:43 pm, "Captain Paralytic" <paul_laut...@yahoo.com>
> wrote:
>
> > On 31 Jan, 13:31, "Mayoutze" <jonathan.ma...@gmail.com> wrote:
>
> > > Hi everybody, here is my problem.
>
> > > I have an entire column containing numeric data like "299.00". I have
> > > to suppress the ".00" at the end. As I have approximately 2000 rows
> > > I'd be glad if you could help me...
>
> > > Thank you...
>
> > What is the datatype of the field?
>
> the datatype is decimal...

So you can either use FLOOR (as Luuk was sort of suggesting) or CAST

On Jan 31, 4:27 pm, "Captain Paralytic" <paul_laut...@yahoo.com>
wrote:
> On 31 Jan, 14:56, "Mayoutze" <jonathan.ma...@gmail.com> wrote:
>
>
>
> > On Jan 31, 2:43 pm, "Captain Paralytic" <paul_laut...@yahoo.com>
> > wrote:
>
> > > On 31 Jan, 13:31, "Mayoutze" <jonathan.ma...@gmail.com> wrote:
>
> > > > Hi everybody, here is my problem.
>
> > > > I have an entire column containing numeric data like "299.00". I have
> > > > to suppress the ".00" at the end. As I have approximately 2000 rows
> > > > I'd be glad if you could help me...
>
> > > > Thank you...
>
> > > What is the datatype of the field?
>
> > the datatype is decimal...
>
> So you can either use FLOOR (as Luuk was sort of suggesting) or CAST

I'll try that!!! Thank you :-)