Hi SSCoach, it does works great, Instead of "," if I want to put <p> how do I do that? I try all the position but it display at first

Thanks

As I said I am new so, I answered what I knew. I know that not fully correct or that's partially correct. After that He move different question.

Since I am new, I did say I will use Index. Then I said I will look at execution plan, and figure out why it is taking so long time....

Dear David,

I am need in SQL Server, it was asked in interview.

Ok I got it thanks

Thank you so much you all.

No I donot have any cluster or pirmary or unique key in table, but as Antares686 said

select EmailAddress FROM omar.dbo.a123 where EmailAddress like 'ca%'...

Thanks Lynn Pettis,

I do like your answer, if query optimizer table scan is best rather then index seek.

create table omar.dbo.a123

(

contactid char(10),

firstname varchar(20),

emailaddress varchar(20)

)

CREATE NONCLUSTERED INDEX IX_NC_PresidentNumber

ON omar.dbo.a123 (EmailAddress)

Let's assume, there...

I used, following index.

CREATE NONCLUSTERED INDEX IX_NC_PresidentNumber

ON omar.dbo.a123 (EmailAddress)

Thanks Lutz, its really help me to google it.

somebody know the answer

Thanks, it work with constraint.