Gossamer Forum
Home : General : Databases and SQL :

sql + fail to replace

Quote Reply
sql + fail to replace
Hi,

with the following sql command,

replace("ab cd"," ",'')

or

replace("ab cd",char(32),'')

Result is

"ab cd"

but not "abcd"

what i want the result is "abcd"

i don't know why, pls help & thanks a lot.
Subject Author Views Date
Thread sql + fail to replace ssharon 3248 Oct 20, 2002, 8:19 PM
Post Re: [ssharon] sql + fail to replace
Alex 3058 Oct 21, 2002, 12:08 PM