CREATE TRIGGER trgsolicitudes
ON solicitudes
FOR UPDATE, insert
AS
BEGIN
update solicitudes set NombreCompleto=(select ltrim(rtrim(isnull(nom,'')))+' '+(rtrim(isnull(ape_pat,'')))+' '+(rtrim(isnull(ape_mat,''))) as
'Nombre' from fusu_usr where id=id)
END