I am creating a JOBNO using a trigger (VB front end). The code below works fine. However, when I insert a new record (via SPROCS) or manually and the JOBTYPE is not 'TAL', it always replaces the assigned value for the JOBNO to null.

I removed the trigger and my SPROCS and manual entry works fine. Any ideas would be appreciated.

Thank you.



Code:
CREATE TRIGGER tr_CREATE_TATL_JOBNO ON [WorkOrder] 
FOR INSERT
AS

Declare @JOBNO varchar(10)
Declare @JobType varchar(3)
Declare @WorkOrderID int
Declare @VRUTimeLine varchar(7)

SELECT @JobType = JobType FROM inserted
SELECT @WorkOrderID=WorkOrderID FROM inserted
SELECT @VRUTimeLine = VRUTimeLine FROM inserted

IF @JobType="TAL" 
	IF LEN(LTRIM(STR(@WorkOrderID))) < 6
		BEGIN
			SET @JOBNO = LEFT(@VRUTimeLine,2) + RIGHT(@VRUTimeLine,2) +  REPLICATE('0',6-LEN(LTRIM(STR(@WorkOrderID)))) + LTRIM(STR(@WorkOrderID))
		END
	ELSE
		BEGIN
			SET @JOBNO =  LEFT(@VRUTimeLine,2) + RIGHT(@VRUTimeLine,2) + RIGHT(STR(@WorkOrderID),6)
		END		
	
UPDATE WorkOrder SET JobID=@JOBNO WHERE WorkOrderID=@WorkOrderID