•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 426,876 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,327 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 5848 | Replies: 12
•
•
Join Date: Nov 2005
Posts: 13
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
MSSQL Where Statement Problem
I want to select all in a column if variable = null
I am placing a php variable in there and i know how to do that so i no that is not the problem but i want a where statement to return all rows of its column when it is null
I want this to select all and not just null rows if somone can help me out i would really appreciated it! :eek:
I want to select all in a column if variable = null
I am placing a php variable in there and i know how to do that so i no that is not the problem but i want a where statement to return all rows of its column when it is null
SELECT * FROM mytablename WHERE (mycolumnname = '')
I want this to select all and not just null rows if somone can help me out i would really appreciated it! :eek:
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded ModeOther Threads in the MS SQL Forum
- Previous Thread: help with joins
- Next Thread: Converting a string to number
