SQL statment

[davidmcolaco]

Hi,
I have a table with data from costumers, but now I had a new field called "state". What I need now is to fill up that field with some parameters.
For example, I want to make an sql statement that says if the city is lisbon, amadora or cascais, the state is lisbon and so on.
How can I do that?

Thanks in advance.

 

[PHV]

Something like this (SQL code) ?
UPDATE yourTable
SET [state] = 'lisbon'
WHERE [state] Is Null
AND city In ('lisbon', 'amadora', 'cascais')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[davidmcolaco]

It's helping a lot.
Just one more question.

If I want to insert the state by the phone numbers, how can I tell him to look in numbers started by 214 for example.

Thanks.

 

[PHV]

Like '214*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886