sqlcmd access : password with special character

Question

I try to access with sqlcmd by this command:

sqlcmd  -U sa -P $test$ -S hostname -d db_test -i .\prova.sql > upgrade.log

but the login failed.

The password I correct, I think is a problem with special character, in this case the $.

Do you have any solutions?

Answer 1

the solution is to use the "", in this case:

-P "$test"