Hyaa, you are right as per my thought. Here is my SP: CREATE procedure up_test_delete( @test_id int ) as delete from tests where test_id=@test_id delete from (another table) where file_name =’filename.aspx?test_id=’+CAST(@test_id AS VARCHAR(100) Let me know if it helps you . Regards