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
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
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.