@dq() Function

Top  Previous  Next

@dq() function doubles the quote characters existing in the given string and returns it.

Syntax:

@dq(string-expression)

 

Example:

INSERT INTO NOTES (TITLE) VALUES ('@dq(TITLE)');

 

If the value of TITLE symbol is Suzan's Apartments then the result would be.

INSERT INTO NOTES (TITLE) VALUES ('Suzan''s Apartment');