Hello all,

I have a database question for you. I have a table in SQL 2000 that I think I need a trigger for. I'm tring to get the trigger to take the last two numbers from one field and replace the number in another field on the same table, see my example that follows:


Before Trigger

Table: Job
J_User1: 0122567801
J_JobType: 20

I would like to take the last two numbers...