How can I escape chars in Liquibase?

General Discussion
1

Hey guys

I have an issue with sql server.

I have a changetype sqlfile with a stored procedure and it includes this line SELECT REPLACE(@test, '\', ':')

Liquibase is assuming all what is following the '\ as part of the string and this is failing. Although the procedure works fine on mssql

How could I fix that?

2

You could try the tag splitStatements:false

3

Hi @hasanagh, would you please post the output from the:
liquibase updateSQL
command?

This will help us see what liquibase has interpreted the source stored procedure as.

Thanks!

Ronak