BCP Copy works from command line but not batch file when using LIKE

[bmacbmac]

Hello. I am trying to run the following BCP script:

c:\binn\bcp "select script from backupdatabases..backupscript where dbname like 'a%'" queryout e:\mssql2000\mssql\backup\backupscripts\backupA.txt -S servername -U username -P password -c

If I type this manually from the command line it runs perfectly and exports 5 lines to the resulting text file.

If I run as a batch file, I pretty much get the bcp /? window that shows the usage and all of the switches.

As a side note. The batch file works great if I change [LIKE 'A%'] TO [= 'ADAMS']. The script seems to fail when using LIKE and a % wildcard.

I also tried putting the database directly after the c:\binn\bcp:

c:\binn\bcp backupdatabases "select script from backupscript where dbname like 'a%'" queryout e:\mssql2000\mssql\backup\backupscripts\backupA.txt -S servername -U username -P password -c

If I run as a batch file I get the same bcp /? window. If I run directly in command line I get an error: "Copy direction must be either 'in', 'out', or 'format.'

Any idea what is different in a batch file vs typing directly into command line where it won't use the LIKE clause?

Thanks!

 

[gmmastros]

Because this is a batch file, you need to double the % symbols.

c:\binn\bcp "select script from backupdatabases..backupscript where dbname like 'a[!]%%[/!]'" queryout e:\mssql2000\mssql\backup\backupscripts\backupA.txt -S servername -U username -P password -c

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gmmastros]

I suppose I should also have given a reference.

http://support.microsoft.com/kb/75634

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bmacbmac]

Worked Great. Thanks once again!