Create A query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Create A query

Author

Topic

Taylor
Starting Member

1 Post

Posted - 2012-06-25 : 06:08:43

Hi I wish to create a query that brings back null record from three fields in a table but I don't know how to do this adding them to the WHERE Cluase. So far I have written the following query

SELECT *
FROM [ApplicationName].[dbo].[Table]
WHERE forename Is NULL

Any help on this will be greatly appreciated.

Paul Taylor

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-06-25 : 06:10:12

>> I wish to create a query that brings back null record from three fields in a table
No idea what that means - maybe

SELECT *
FROM [ApplicationName].[dbo].[Table]
WHERE forename Is NULL
or surname is null
or middlename is null

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources