Check record and insert with in one query insert int tbl (Col1,col2,col3) select col1,col2,col3 from tbl where col1=”val”