Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mnttr
Starting Member
9 Posts |
 Posted - 2002-09-09 : 07:46:26
|
| how can get the "select distinct" result when the table has a text fieldjust like :select distinct * from tablename |
|
|
dsdeming
479 Posts |
Posted - 2002-09-09 : 08:15:02
|
| You can exclude the text column from the column list. Or you can try converting the text column on the fly:create table #a( a int, b text )insert into #a select 1, 'barney'insert into #a select 1, 'fife'select distinct a, cast( b as varchar( 8000 )) from #adrop table #a |
 |
|
|
|
|
|
text field