Data Error

[JezBullen]

Hi,

I've got a database set up for printing different letters depending on which one the user selects. The letters display the customers address (taken from the customer table) as well as other details (taken from the warranty table)

For some reason, when the customer code "C001" (a valid customer) is entered, the system stops working, because this is stored as "C001 C001" in the Warranty table and the join part of my query doesn't match up

Does anyone have any suggestions - I can't think why this particular field value should pose such a problem

Thanks in advance
Jez

 

[mwolf00]

Sounds like someone goofed...

UPDATE warranty SET customCode = "C001" WHERE customerCode = "C001 C001"

OR, more genericly

UPDATE warranty SET customCode = left(customerCode, inStr(customerCode," &quot -1) WHERE inStr(customerCode," &quot > 0
Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com