Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

delete nulls or no values

Status
Not open for further replies.
dav667

dav667

Programmer
Apr 3, 2003
3
GB
if there are nulls or no values in a field called url
can i delete these records with this sql statement

delete from table where url=''

thx.
 
Sort by date Sort by votes
Nearly:

Code: 
DELETE table_name
WHERE url = ''
  OR url IS NULL
--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
386
CodeWell
CodeWell
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
308
dgillz
dgillz
mrmovie
  • Locked
  • Question
ODBC connection, or other from Linus system using AD account details 2
Replies
2
Views
151
mrmovie
mrmovie
tekpr00
  • Locked
  • Question
Hello I am new to a new organizatio
Replies
1
Views
123
johnherman
johnherman
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
366
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top