Archives of the TeradataForum

Message Posted: Wed, 02 Apr 2003 @ 16:06:06 GMT

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

Hello,

I have seen several of the responses using the escape character to get at what you want.

Another way would be to use a combination of the substring and characters functions to check the last two characters for your target values.

Can anyone comment on which would be more efficient if relevant. Does the use of the % cause more parsing than specifying exactly which characters to check?

Jim

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