Is there any way I can comapre the new value of text, ntext and image with
the existing text, ntext and image column value. I have to do validation if
that text is not exist then it should inserted otherwise not..

Anyway I can do this validation?

Thanks in advance.

Hello,
You may check for NULL but cannot compare the values.
Example:
SELECT * FROM SomeTable WHERE TextColumn IS NULL

Hope that helps.
Amit Basu

"Rogers" wrote:

Hello,
You may check for NULL but cannot compare the values.
Example:
SELECT * FROM SomeTable WHERE TextColumn IS NULL

Hope that helps.
Amit Basu

"Rogers" wrote:

Hello,

You can check for existence of data only and not compare values like:

select * from SomeTable where TextColumn is null

Hope that helps.

Amit Basu

"Rogers" wrote: