467,915 Members | 1,213 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Hello there

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
  • viewed: 899
Share:
3 Replies
Nepomuk
Expert 2GB
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 2GB
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
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.

Similar topics

24 posts views Thread by Andy Sutorius | last post: by
2 posts views Thread by bissatch | last post: by
16 posts views Thread by saurabhnsit2001 | last post: by
18 posts views Thread by arnuld | last post: by
1 post views Thread by James T. Dennis | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.