|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/31/2007 10:09:02 AM
Posts: 7,
Visits: 3
|
|
I'm trying to send an argument to a table function, with single quotes in the argument string, e.g.:
select x from table (y('I need single 'quotes' in here') as z;
I guess it just needs a better understanding of Teradata SQL, but that's not my forte. It should be the same solution as containing single quotes in any string in SQL.
Thanks,
David
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/31/2007 10:09:02 AM
Posts: 7,
Visits: 3
|
|
The example should have read
select x from table (y('I need single 'quotes' in here')) as z;
of course
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 4:26:39 PM
Posts: 125,
Visits: 275
|
|
Escape the single quote with another single quote.
select x from table (y('I need single ''quotes'' in here')) as z;
Shaw
|
|
|
|