Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

sql + fail to replace

Oct 20, 2002, 8:19 PM
ssharon
New User (0 posts)
Oct 20, 2002, 8:19 PM
Views: 4968
Shortcut
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 4968 Oct 20, 2002, 8:19 PM
Post Re: [ssharon] sql + fail to replace 		Alex 4657 Oct 21, 2002, 12:08 PM