BaseNow Forums

Home

Member List

Subscribe to all forums

» BaseNow Forums

» Questions

» Compare SQl fields

Welcome Guest ( Login or Register )

Active Topics |

Popular Topics

Compare SQl fields

Author

Message

Posted 6/21/2006 1:13 PM

Forum Member
Forum Newbie

Group: Forum Members
Active: 6/26/2006
Posts: 1

Is there a way to look at a sql table that contains street, city state and zip. I want to compare the values in the city, state, and zip field to the street field and delete the matches in the street field

IP Logged

Posted 6/23/2006 11:42 PM

Forum Administrator

Group: Advanced Members
Active: 8/9/2024
Posts: 64

Try executing a SQL query. For example:

UPDATE CUSTOMERS SET STREET = '' WHERE STREET = CITY + ', ' + STATE + ', ' + ', ' + ZIP

For more information, please visit this web page:
http://www.basenow.com/help/Run_SQL.asp

IP Logged

Showing page 1 of 1 - 2 messages found

« Next Oldest :: Next Newest »