Sql Query

Accepted answer

The problem is that '[' is one of the special characters used with the LIKE operator:

http://technet.microsoft.com/en-US/library/ms179859(v=sql.100).aspx

If you want to use it with its natural meaning, then you have to 'escape' it:

Here are two ways in which you could do that:

select * from table where username like '[[]ks%'

or:

select * from table where username like '![ks%' escape '!'

Khan Abrar Ahmed12y ago

Hi use this
DECLARE @table AS TABLE (cValue VARCHAR(64))
INSERT INTO @table
        ( cValue )
VALUES
        ( '[ks' -- cValue - varchar(64)
          ),

        ( 'ks' -- cValue - varchar(64)
          )
        select * from @table
        select * from @table where cValue like '[[]%'

Sagar12y ago

but why i cant search with '[' i need to search with '[' and its not working

Anupam Singh12y ago

Hi jain,

try : select * from table where username like 'ks%'

will work as expected.