Your prediction was right. I found all different formats of sheet number after running your select statement. Thank you so much to you all and especially to Ramesh.

Dong

Ramesh,

Last reply I posted was for Lowell. I thought the reply would go right underneath the one replied to. I ran your sample code and it worked fine, but it...

Thank you for your reply.

I got the same error message that posted earlier.

Server: Msg 170, Level 15, State 1, Line 3

Line 3: Incorrect syntax near '<'.

I ran the script as...

I got another error this time.

Server: Msg 8152, Level 16, State 9, Line 1

String or binary data would be truncated.

The statement has been terminated.

Thank you for your reply. The script you posted gave me an error message that I kept on getting. Here is the error message.

Server: Msg 170, Level 15, State 1,...

It works. Thank you Ryan.

Thank you Paul. I'll try the link.

It's a little disappointing but thank you. I'll try your solution. Thank you.

Thank you for your response, Dave.

I'm attempting to manipulate the variable name to avoid hard coding. So far your second assumption is valid, but it can be changed down the...

Thank you all for the replies. I appreciate that.

With your information I created a form with a text box and a picture box on it, and loaded a picture...

I used Kevin's method because I ran your code to get an error message 'conversion error'. I found a project number 'DM05-012-02'. I have no idea how it got in...

Ok. Thank you.

Thank you, Remi. It worked. What do you call this kind of query? I'd like to read more about this from BOL. Thank you.

Thank you for sharing your experiences. I guess I'll stay away from the backup software and save some money.

Yes, it seems to happen every time I click on the properties menu. I haven't traced. Do you trace it with performance monitor? Could you give some details on tracing?...