Archives of the TeradataForum

Message Posted: Tue, 14 Mar 2006 @ 15:56:02 GMT

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

I have not followed all the notes related to this topic , so excuse me if I am repeating any thing. Muktar, it sounds like a Stored Procedure is what you need. If you are able to create one then you can check the length of every record on the field that you are working using CHAR_LENGTH function. Now Trim you spaces by looking for ' ' and loop through your length.

Hope this helps.

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