How can I copy a SQL column to another column and ignore nulls?

UPDATE your_table
SET some_column = some_other_column

>I'm running into an issue with the one that I'm using because there are nulls in the column
So ... what's the issue?  If some_column is set to NOT NULL, then you can use ISNULL() to convert them to some other value

UPDATE your_table
SET some_column = ISNULL(some_other_column, '')

Hi Jim,

The new column is set to null, but when I run the same command that you mention I get:

Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.

Thanks,

Brian

Hi Jim,

I was able to accomplish what I needed done by using

UPDATE my_table
SET date = CAST([field2] AS DATE)
WHERE ISDATE([field2]) = 1

Thanks for your help.

Whah

Thanks for the grade.  Good luck with your project.  -Jim