Thanks that works great!

Thanks for you help....I guess I was having trouble telling you guys what I really needed. I could see it in my mind but hard to convey in words....

Sorry about the title...but this is the correct way to get what I wanted. Your way still left off the end numbers.

SUBSTRING(col,PATINDEX('%[^0]%',col),10)

05380101010000

05380101020000

05380101101000

05380011103000

I am pulling them like this:

SUBSTRING(REPLACE(LTRIM(REPLACE(col1, '0', ' ')), ' ', '0'), 7, 3)

This works for the the first two numbers but not for the last two.

Outputs the following:

101

102

101 but...

In this case I have both.

I got this backup file from some accounting software I use.

I get the following error....Server: Msg 3242, Level 16, State 1, Line 1

The file on device 'F:\ponic.bbk' is not a valid Microsoft Tape Format backup set.

I guess there is no...

Do I have to modify this trigger to work with my database? When I try to run the trigger in SQL2000 it blows syntax errors? Can anyone help?

Sorry...