Replacing (,) from a field

[binayr]

In a table I have a address field which contain addresses and I want to remove , with blank e.g 1234 cl dr, la 1111 to 1234 cl dr la 1111. Please help me out I'm new

BR

 

[LKBrwnDBA]

Will depend on you DB flavor, but it seems that REPLACE(col,',',' ') is almost universal.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[binayr]

How to find out what are the changes i have made in catalog e.g I have catalog-v1.0 and made a copy of itcatalog-v1.1 and make lot of changes now i want to find out are the changes I have made

BR

 

[LKBrwnDBA]

Sorry, I don't understand what catalog-v1.0 and itcatalog-v1.1 are.

You may want to post that question in the specific language/database forum.

Cheers.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb