Archives of the TeradataForum

Message Posted: Sun, 03 Jun 2007 @ 22:42:31 GMT

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

Hi,

is it possible to remove two blanks in a data to make it one blank in one single select statement?

e.g

My Choice 55 Test/TXT

Is it possible to remove the two Blanks between 55 and Test to have only one blank in one single SQL.

Thanks,

John Mathew
IBM India
Vodafone Australia DW & BI

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