By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Hello there

P: 2
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
Share this Question
Share on Google+
3 Replies


Nepomuk
Expert 2.5K+
P: 3,112
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
Expert 2.5K+
P: 2,878
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

P: 2
Hello ck9663
Thank you so much for the help. I did work. Good job.
Sep 11 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.