You could use the exists() fucntion

if exists(select ....)
--Begin Code

Eric

>Sergey,
>
>Thanks. I you've given me the syntax I'm looking for. To test for not found, would I do as follow?
>
>IF (@Parent_Lsonid IS NULL) or (@Parent_Rsonid IS NULL) BEGIN
> error coding here...
>
>
>Thanks.