Hello guy's

I think you havent got my problem.......

I m providing an example

I have Table Project_CreateMainTask

ID ProjID UserId UserType Task ...

Thanks Garadin...........

Problem is solved.....

I tried it like that but it did not work.....

Actually i want to delete the record which will have @path as as substring in path........

example

suppose tableName contain entries as

ID...

Thanks yaar ......

I tried it like that but it throws an error when int range limit is exceeded

Thanks Suresh you have solved my problem

Instead of case you can write query as

select * from infosys

where Integrity != 0