SQL Server

[Guru]

Msg 402, Level 16, State 1, Line 1
The data types text and varchar are incompatible in the equal to operator.

What should I use instead?



Thanks

[Hack]

What gives you that error?

What are you trying to accomplish when you get it?

[The_Duck]

You need to compare using 'LIKE', e.g.

SELECT * FROM MYTable WHERE MyTextColumn LIKE 'Value'

[Guru]

Yay!
Thanks again

These may seem pretty simple questions but I very rarely use SQL Server; more familiar with Oracle really....

[Guru]

Next question:

How do I a "group by" or "select distinct" on a text field?



Thanks

[Hack]

What is your complete SELECT statement?

[szlamany]

Why are you using TEXT fields?

They have many limitations...

[Guru]

select drive from tbldata group by drive


select distinct drive from tbldata


Typical values for drive would be:
\\000.000.000.000\Apps (D)
\\000.000.000.000\Data (E)
\\000.000.000.000\System (C)



What data type should be used instead of text?

[szlamany]

varchar(x) where x is some value for the max length.

nvarchar() is for unicode data - doesn't appear that you have that requirement.

text is for really large fields and has all kinds of limitations - as you have discovered.

[Guru]

OK thanks, I'll give it a go