Bulk Change Customer Price Level

Hi Chris

Try.... update customer set pricelevel = 1 where accountnumber between 0101010 and 1010955;

I beleive account numbers are 7 digits;

To roll back to all customers having "standard "price level use update customer set pricelevel = 0

H> We recently instituted a customer loyalty program. I need to set the price

I assume you instructions are for a SQL Query to be run in the administrator. I tried but got a syntax error. Am I missing something?

A new twist to the issue. We have several types of numbering for account numbers including alphanumeric, and phone numbers for some accounts. Running the query suggested I get the error

Any suggestions to get around this?

ALWAYS, ALWAYS, ALWAYS BACK UP YOUR DB BEFORE RUNNING Update, Insert or Delete QUERIES!!!

accountnumber is a string, not a numeric field - put single quotes around the values...

where accountnumber between '0101010' and '1010955'

Note that '0101010' IS NOT the same as '101010' in a character field - the leading zero really does make a difference in this case.

You might want to run a select statement using the same where clause before running the update just to verify that you are getting only the records you want...

select * from customer where accountnumber between '0101010' and '1010955'

--or to get just the count of the records,

select count(*) from customer where accountnumber between '0101010' and '1010955'

Glenn Adams Tiber Creek C> I assume you instructions are for a SQL Query to be run in the

Glenn - Thanks that did the trick.

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news: snipped-for-privacy@TK2MSFTNGP03.phx.gbl...