Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replacing (,) from a field

Status
Not open for further replies.

binayr

Programmer
Jul 3, 2006
19
US
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
 

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



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

BR
 

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

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top