You can use BREAK statement. But as Gail told, it should be useful to you, if you post the code.

But i did some test to come out from the cursor. Here is the code

create table test

(

col1 varchar(10),

col2 varchar(10)

)

go

insert into test

select 'aa','ram'

union all

select 'bb','ram'

union all

select 'cc','ravi'

union all

select 'dd','rahi'

go

create proc p1

as

begin

declare @col1 varchar(10)

declare c1 cursor

for select col1 from test

for read only

open c1

fetch c1 into @col1

while @@fetch_status = 0

begin

if @col1 = 'cc'

break

select @col1

fetch c1 into @col1

end

close c1

deallocate c1

end

go

exec p1