Hello there

[shimaafshari]

I am a new member with a question. Hope someone find an answer for me. I am using sql server. I have two column in my database and need to add some text to the column one where ever column two is not null. I can not find the right statement to do the job. Thanks

[Nepomuk]

Hi shimaafshari! Welcome to bytes.com!

It's great to have you here! You should ask your question in our SQL Server Forum, where people will surely be able to help you.

When you post, please always keep to the Posting Guidelines and when you post code, please post it in [code] ... [/code] tags.

Otherwise, I'll just wish you the best and hope you enjoy being part of bytes.com!

Greetings,
Nepomuk

[ck9663]

I guess it's back to school already huh :)

Here are the t-sql that you would need.

UPDATE

Check if column2 is null. Use this

and the WHERE clause.

Good luck.

-- CK

[shimaafshari]

Hello ck9663
Thank you so much for the help. I did work. Good job.