By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

check new customer is exist in table

P: n/a
hi all,

I have one question like that:

I have one customer table: customerID, name,address,phone,zip.......
I must check the customer in this table or not before insert it. The
records of the table is 1000K, I will check the zip, name and address,
if all are same, it is exist. but sometime address is not matching
100%,
like: "1111 N robinson ok city" and "1111 N Robinson oklahoma
city"
or "111 N robinson street" and "111 N robinson ST"
anyone can give me some advice?
Thanks
Alber
Feb 14 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.