Hi Ramesh,

No worries.

'¬' is just a somewhat unusual keyboard character (it's on the key under 'Esc' on my keyboard). You can run this to select it...

select char(172)

I should've...

That's good to know, David. Thanks for the info.

See:

http://weblogs.sqlteam.com/mladenp/archive/2005/08/01/7421.aspx (no 5)

or

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx

For your example...

--data

declare @ColorChart table (Colors varchar(10))

insert @ColorChart

          select 'red'

union all select 'green'

union all select 'blue'

union all select 'purple'

union all select 'green'

Hi all,

FYI - The 'IsReallyNumeric' function in this link does what the (useless) 'IsNumeric' function should!

http://aspfaq.com/show.asp?id=2390

Hi all,

Yet another way!

It deals with all the different types of test data I can think of...

--data

declare @t table...

Thanks lakusha. I'll have to wait till we get SQL 2005 to be able to work through this, but it makes interesting reading in the meantime! 

Of course I'm interested!

Not that I have access to sql 2005 yet, but still, I am interested

Did the example I gave illustrate your...

I don't know how you guys can work through these things without examples. I find it impossible .

RGR - I don't get what you're...

Yep - I agree with all of that

I can't think why you think it looks like a big mess!

For a start there's nothing in the proc which tells anyone...

end-user - did you have an answer to Vladan's question? You need to decide which 1 of those 3 rows you want.

If you can tell us, then it's easy for...

+1 for John's suggestion.

Note that the clustered index isn't a guarantee that the data will be sorted, so you should still use an 'order by'. It should be much quicker...

Hi all,

I suspect (i.e. know ) this is overkill  - and particularly since you seem to have an answer you're happy with - but here...