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.
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.