Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  A Query to Replace values

Author  Topic  BOLNet Starting Member 5 Posts Posted - 2001-10-08 : 06:03:18 Hello, I need to replace the values of a field called idDistricte, if equal to 0 for another value, for example 55, could you help me please? The select statement is: SELECT * FROM [local] WHERE (idDistricte = 0) AND (idTipusLocal = 1) and I want to replace the value 0 for 55. Million thanks.