sswords - not to get sucked into the digressive path (how long could it have lasted anyway...) but nothing like BBC to give everyone a run for their money...as for...

LOL....stream of consciousness at its' best....

GPF....your mind is beginning to wander - gather your thoughts quickly and try to put them in some cohesive order...and most importantly - "stay on...

National Public Radio...

I think it depends Noel - I have full control over my db at work and KNOW it's never going to change - it might be torn down and rebuilt...

darn - the free shipping must be recent - I just got my boxed set from Amazon 5 days back...missed the boat as usual (pun intended)

right - all the "trims" are string functions to trim the leading/trailing blanks/spaces...

you could use "select cast(Total as decimal(10,2))" though...which works just like "convert" (except for formatting) AND is ansi...

Brian - I'm sure that that 7th grader is an exception...not the rule!

Anybody who has even remotely dreamed of authoring something is well aware of the distinctions between originality, poetic...

glad it all worked out!

"see" you around Mike!

ivelisse - maybe you still had the "distinct" in your query without realizing it ?!

select * from test - should give you all 11 rows.

select distinct * from test -...

you "order by" exactly as it sounds...

select distinct * from test

order by company, date, unit...(or whatever order you want to specify!)

oops - colt 45 is drawn and at the ready!

here's the wholet thing from start to finish - apologies for the mishmash of upper and lower case...is late..

create table bets

(betid int,

drawid int,

userid int,

num1...

hmm! I just ran Nicolas' code against a test table and it worked fine...do you get any error messages at all ?! I inserted all the data exactly as you...

ivelisse - there is only one distinct company you have - abc company - if you want all the columns, you need to do a "select distinct * from test"....

ivelisse - could you please post what you ARE getting and what you WANT to get ?! thx!