cmsmoon
New User
Joined: 17 Jun 2010 Posts: 75 Location: Chennai
|
|
|
|
Hi Friends,
I have table with fields..In that some field value have special charaters .I want to write aquery to disply values without special charater('/') . example
Name Address Shop_adress
raja 16/2009,east st 120/200 . West street
ravi 12/9002, best street 90/23, south street
will be selected like this
Name Address Shop_adress
raja 162009east st 120200West street
ravi 129002best street 9023south street |
|