I leave office around 10 in night and not able to go to bed before 12. Due to this its late in the morning. How can I do any excercise...

you have stuffed spaces thats why this sql is not working properly, but this is only the logic, it does not meant that it will work with all the possible...

Create table temp222 (ID Int identity(1,1),Skilltype varchar(1000))

go

INSERT INTO TEMP222 (Skilltype) select 'c, c++ (6),web development (6), java (3), unknown (21)'

INSERT INTO TEMP222 (Skilltype) select 'c# (15), design (12),windows (12),...

Sorry I written table temp222 instead of temp

select * from temp where ','+skilltype+',' not like '%,c,%'

Hi

Use this SQL

select * from temp222 where ','+skilltype+',' not like '%,c,%'

Thanks

Vaseem

Hi,

The two techniques are logically equivalent but can have vastly different performance hits depending on how the parser

plans the query.

Not where clause replace Join nor vice versa.

Where clause works on...

You can try DTS. Create a DTS for this and execute to transfer data.

-Vaseem

Hi,

Why dont u simply put like

select sum(1) from table

Vaseem

Hi

The best method to copy objects (with/without data) from one database to another I think is Import/Export method.

Thnx

Vaseem