yokzu

yokzu

  • NA
  • 306
  • 0

Select query with dots

Apr 3 2012 4:34 AM
Hi,
I want to search an IP address from DB. Query is like below;

select * FROM Log WHERE IP='3.3.3.3'

But I get this error,

"The data types ntext and varchar are incompatible in the equal to operator."

IP colon's format is "nText".

How may I search IP addresses?

regards.


Answers (6)