Whoa...don't know what kind of communications barrier this falls under but nobody was being rude - either politely or otherwise...they were just trying to explain that it is my "signature...

well guess what...I brought the popcorn but was too rivetted to have any!!

I was trying to understand the question since I hadn't heard of "Stored function tables"..UDFs - yes; stored procedures - yes; system functions - yes...hence my need for clarification!

That being...

can you please expand on that question and give some sort of a context ?!?!

"Matt Lauer has been co-anchor of NBC News’ Today since January 6, 1997. He joined

Today in January 1994 as news anchor. From September 1992 to September ...

In a June 2005...

In addition to BOL you may want to read this other post which addressed a similar issue..

but WHY the difference ?!?! Has it anything to do with our db collations ?!?!

okay - change the column from "text" to "ctext"..

sql 2k - sp4 - get the exact same error msg as farrell does..

why don't you just create a view then ?!?!

reminds me of some commercials I've seen lately.."what frequency are you on" - to echo farrell - what version of SQL Server are you using Noel ?!

You can script the table and then use find/replace to replace it with a new table name..that way you'd have an exact copy! Is that what you're asking ?!

How about scripting them into individual files and checking file size ?!?!

this should get you all the first occurences...if it doesn't, please post some more sample data...

select a.* from myTable a
inner join
(select min(pro_id) pro_id from myTable 
group by pro_seq, pro_mix,...