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

Sep 9 '08 #1

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

Sep 10 '08 #2

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

Sep 10 '08 #3

shimaafshari

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

Sep 11 '08 #4