Archives of the TeradataForum
Message Posted: Fri, 04 Mar 2011 @ 14:23:33 GMT
I have a macro with following data types for the parameters
REPLACE macro Part_Lookup (part_id INTEGER, description VARCHAR(120)) AS (........................)
I want to pass a value for second field with apostrophe(') as a character in the description as below
Example: Exec macro Part_Lookup (2345,"motor's");
Here when, I am passing the value "motor's" as search string in description, it is giving following error
[Teradata Database]  Syntax error, expected something like ')' or ',' between a string or a Unicode character literal and the word 's'.
I want the character (') also to be considered in the search string and get result containing the word motor's in the description.
How can I achieve this result and have escape character for (') apostrophe?
Please help.. Thanks!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|