Archives of the TeradataForum

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

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

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"

Suman

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