Select query with dots

Vulpes     :-) 

Hi,

If you defined a column as integer then you can directly search by the value.

CREATE TABLE Example
(
        ID INT IDENTITY(1,1) PRIMARY KEY,
        Name Varchar(10)
}

Here the Id is integer column and name is varchar.

When you write the search ID then

SELECT * FROM Example WHERE ID=2

If you want to search the exactly name then

SELECT * FROM Example WHERE name='Senthil'

If you want to search the similar kind of names then

SELECT * FROM Example WHERE name LIKE '%Senthil%'   --It will search the senthil which consist some thing like 'kumarsenthil'

SELECT * FROM Example WHERE name LIKE '%Senthil%'  --It will search by name starts Senthil like 'Senthilkumar','SenthilRaja'   

SELECT * FROM Example WHERE name LIKE 'Senthil%'   -- It will search the name some thing like 'KumarSenthil'

I come to your example,


SELECT * FROM Log WHERE CAST(IP AS nvarchar(4000))='3.3.3.3'

This will help you to fix.
If it is useful then mark it as "Correct Answer"

Thanks for your repley vulpes, I changes my query like below;

 "SELECT * FROM Log WHERE IP=CAST('"+TextBox3.Text.ToString()+"' as ntext)";

But I get this error; The data types ntext and ntext are incompatible in the equal to operator.