We currently are running merge replication between SQL Server 2000 and several handhelds. We run into issues where we occasionally get conflicts and I would like to write my own procedure for handling them. The resolution is quite simple. We have a column "Status" (integer) that gets updated when an action is performed on the handheld for that particular record. Therefore, if "Status" is higher on the handheld side, I want that record to win...but if it's higher or equal to the server side, then don't let it win. My question is how can I do this easily? I've seen things such as creating visual basic apps, etc. to handle this, but can I create a stored procedure just the same?

Thanks,
Jeff