Loading

SQL Query problem

Sagar

12y1.3kSQL

i m storing a column value as '[ks' and why this query return nothing ???

select * from table where username like '['+'%'

i must need to search it in this way so how i can do this..........

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

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 '[[]%'