Just wanted to comment on the "Changing the data type to money will not put the "$" character with the values..."...

An example from BOL..

CREATE TABLE TestMoney (cola INT PRIMARY...

If you cannot change the data type to money/smallmoney then you can't do it...why do you need to store it in this format ?!?!

Usually formats are used for display...

Oh what an apt name for a vacation spot...I visited the isle of skye once (many moons ago) and it was just as remote and blissfull...nothing quite like getting far...

what's wrong with the result you get from your "select" ?!?!

marketing and networking...what about "fair play"...

Rats...does this mean I have to return the montblanc and notepad...

For the last time (what a sexist site this...

think of the girls......what about the boys ?!

As for you supporting this site, it's common knowledge that you only do so because of the...

What a very high moral tone and how wonderful that it can be taken...Know that Max can well defend himself but I'm just fascinated by the interpretations...I read his response...

Also forgot to mention that you can set an unique constraint on a column where you want to avoid duplicates...still curious about that table though...

"select distinct username"..should remove the duplicates...

but what kind of a table is this that has only one column ?!?!

Carl - if you search this site you're bound to find (at least) several posts with questions similar to yours...

I found one such for you where several members have submitted...

And how is this different from what I posted ?!?!

And what if it were a simultaneous process - what if one was scouring BOL while waiting for an answer from one of the many experts here...?!?!

It IS kosher - what's peculiar is the result that Vishwas got...

That's peculiar 'cos when I ran your statements in QA, this's what I got...

RIGHTHANDPosition_SpaceSpaceHANDPosition_SpaceHAND
RIGHT HAND with one space06
RIGHT HAND with two spaces67
RIGHT HAND with three spaces   ...

Not that I'm clamouring for world peace or anything but why is a basic level of amicability so hard to come by ?!?!