Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 05 Mar 2011 @ 20:09:00 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Apostrophe(') as parameter value in a Macro
From:   SUMAN M

Hi Bob,

Thanks for your response. I tried several options like below but didn't get the desired result

1) 'motor''s' - prefix character for escaping apostrophe - This didn't work as a param value in macro may be it works in only select query

2) 'motor_s' - Wild character - this works but gives all other character between letters "r" and "s"


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023