Hello Serqiy,

Thanks a lot! That's what I want to ask!

But it still generates the error same as the 'where exists' clause. I might need to sovle the duplication problem inside my...

Thanks a lot indeed PW!

It's just so easy under your instruction. It's done! I just left out the index column when I inserted those records.

Hello Sushila,

You are really an expert!

I've done the codes according to your hints. The final code is like below:

Update DBCJW.dbo.Client_Tbl

Set Phone_1 =

(Case when (len(Phone_1)>14 and left(right(Phone_1,5),1)='-'

   and left(Phone_1,4) in...

Hello Sushila,

Thanks a lot for your hints!

My old data column has some phone numbers with one kind of wrong format, and also includes some correct formatted numbers as well.

The wrong format...

Hello Ajay_73,

I find the code below worked for the updating column according to columns in another table.

Update TableA

Set TableA.OldEmail =

(Select TableB.NewEmail

from TableB

where TableA.LastName = TableB.LastName and

         TableA.FirstName = TableB.FirstName)

Where...

Hello David, Paul and Sushila,

The query result pane under the query window in Enterprise Manager doesn't allow me to edit any cell. I can...

Hello ajzy_k73,

Thanks a lot! It worked!

I executed it in Query Analyzer, and it also generated new tables!

I found the codes in SQL Server 2000...

Hello All,

I am a new user of SQL Enterprise, could anybody tell me where to run a SQL command in Enterprise? (not in the Query Designer)

I want to create a...