Archives of the TeradataForum

Message Posted: Wed, 04 Aug 2004 @ 08:00:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You need to escape the single-quote with a another single quote.

     sel 'sel * from tab1 where a in (''' || '12345' || ''')';

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     (('sel * from tab1 where a in ('''||'12345')||''')')
     ----------------------------------------------------
     sel * from tab1 where a in ('12345')

Narayan

	<Prev	Next>		<<First	<Prev	Next>	Last>>