String Escape

This page describes the Data Sync function STRING_ESCAPE()

Overview

The STRING_ESCAPE() function escapes single quotes in data sync parameters by adding two single quotes. It can be used to wrap around parameters or column references respectively. This can be useful when you use it in a post sync script's CQL.

Syntax

STRING_ESCAPE(@yourparameter)

Or

STRING_ESCAPE(@COLUMN('yourcolumn'))

Example

STRING_ESCAPE(This is my data sync's test)

will become

This is my data sync''s test