Create Function getUser_nm (
@puser_id varchar(30)
)
Returns varchar(30)
As
Begin
DECLARE @return_value varchar(10)
select @return_value=user_nm from tbs_user_info where user_id = @puser_id
if(@return_value!='')
RETURN @return_value
else
select @return_value=biz_nm from tbs_biz_info where biz_id = @puser_id
RETURN @return_value
End