Thanks for your responses. It worked well. I appreciate the security concerns. If/when we have to work this way with a vendor, how can we check the files for viruses/worms? Thanks...

Not exactly, we copied the mdf&ldf files (used detach/attach), sent them to our vendor, they updated them and sent them back. So I just detached the database, renamed the old...

I am going to use copy of the backup. Thanks to all for the help.

I was able to get the results I needed by using

format(date_of_birth, "YYYYMMDDhhmmss")

Thanks for the help!

I ran 3 separate steps:

update tablename set phonenumber = replace(phonenumber, '(','')

update tablename set phonenumber = replace(phonenumber, ')','')

update tablename set phonenumber = replace(phonenumber, '-','')

Thanks again for your help!

Thanks it worked with one less replace:

update tablename set phonenumber = replace(phonenumber, '(', ''), ')', '')

How would it go in the backup statement then:

DECLARE @FileSaveDate  varchar(16)

    --  Get and format the date and time to be used in this backup's file name.  Note that 

   ...

I tried adding the name of the backup file and that works:

BACKUP DATABASE CE10 to disk = 'c:\mssql7\BACKUP\ce10_db_0722051200PM'

WITH NOINIT

But how can I get the date and time to be...

Thanks, I was afraid of that. Unfortunatey our tape backup didn't work the last few days.

There is software to be installed on the pocket pc's, but my understanding is SQL Server CE Server Tools will install on the server.