BaseNow - Database Front-End Software
*
Home Buy Download Details Support
BaseNow Forums 
Home
Login Register Member List
  » BaseNow Forums   » Questions   » Compare SQl fields  

Welcome Guest ( Login or Register )


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
This member is offline.
Posted 6/23/2006 11:42 PM
Forum Administrator
Forum Administrator

Group: Advanced Members
Active: 3/7/2010
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
This member is offline.
Showing page 1 of 1 - 2 messages found
« Next Oldest :: Next Newest »

Powered by InstantForum.NET v3.4
Copyright © 2002, 2004, InstantASP Ltd. All rights reserved.