removing embedded blanks

Peter Green

removing embedded blanks
Does anyone know how to remove embedded blanks from a string using a scalar
function


Eg translate a column containing "abc 23" to "abc23" or "ab 23" to
"ab23"

thanks

Peter
____________________________________________________
Peter J Green
EMail: [login to unmask email]



Chris Flink

Re: removing embedded blanks
(in response to Peter Green)
USE THE COMPRESS SQL FUNCTION .....................



Peter Green
<[login to unmask email] To: [login to unmask email]
CO.UK> cc:
Sent by: DB2 Data Subject: removing embedded blanks
Base Discussion
List
<[login to unmask email]
LASSOC.COM>


12/12/02 10:15 AM
Please respond to
DB2 Data Base
Discussion List






Does anyone know how to remove embedded blanks from a string using a scalar
function


Eg translate a column containing "abc 23" to "abc23" or "ab 23" to
"ab23"

thanks

Peter
____________________________________________________
Peter J Green
EMail: [login to unmask email]



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can







**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please destroy
and notify the sender by return mail.
**********************************************************************



Moyeen Khan

Re: removing embedded blanks
(in response to Chris Flink)
Use REPLACE(Col1,' ','') -- The last are two single quotes





Peter Green
<[login to unmask email] To: [login to unmask email]
CO.UK> cc:
Sent by: DB2 Data Subject: removing embedded blanks
Base Discussion
List
<[login to unmask email]
LASSOC.COM>


12/12/2002 11:15
AM
Please respond to
DB2 Data Base
Discussion List






Does anyone know how to remove embedded blanks from a string using a scalar
function


Eg translate a column containing "abc 23" to "abc23" or "ab 23" to
"ab23"

thanks

Peter
____________________________________________________
Peter J Green
EMail: [login to unmask email]



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can