Hi,

Thanks for the reply.

My main concern in this query is how to pass the multiple user inputs for the same column?

User might enter a big sentence with AND /...

How will this work?

Can u pls explain?

Extending the table structure given in the article[/url]

I have added an extra table for UserListing.

CREATE TABLE dbo.tblUser ( codUser INT, codName VARCHAR(20),PRIMARY KEY (codUser));

insert into dbo.tblUser values (1, 'abc');

insert into...

Thanks for the reply.

Thats fine. What If somebody hacks the database and access the mdf file,...

I got the answer. I was using a different...

Hi Amit Khanna,

Thanks for ur reply. I am an asp.net developer, not a dba :rolleyes: but still i have a good knowledge on db.

I have used joins on tables,...

Hi Amit,

Can you (or anybody) explain me how this CTE works..??

I am confused.. 🙁

Thanks in advance..

Thanks a lot Amit Khanna.. 🙂 Great job..

Updating the temp table as done by Arjun tewari will not be a good idea in this case..

declare @i int

set @i=234

update #temps...

create table #Like_Test( Col1 varchar(5) )

insert #Like_Test values('_Cus')

insert #Like_Test values('Cus_')

insert #Like_Test values('C_us')

insert #Like_Test values('Cus')

insert #Like_Test values('Cu_s')

select * from #Like_Test where Col1 Like '%Cu_%'

How can we really get the row...

Here, in India i have noticed that they call us "Software Engineer" not an IT guy, and that looks good. 😉