Hi

i have table with three coulmns(name , phone , ishere as boolean)

i need to create procedure that check name if not exists insert anew record
& if exist delete the insert

thank u

1. Are you using PHP, ASP or something else with SQL to do this????
2. What if you have 2 john how does it work??

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
1. Are you using PHP, ASP or something else with SQL to do this????
2. What if you have 2 john how does it work??

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Hi Roddy

i am not using anything but sql
i already found the answer
thank u