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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Empty strings 1

Status
Not open for further replies.
jimmyshoes

jimmyshoes

Programmer
Jun 1, 2008
132
GB
What is the best way to test for empty strings ?

Code: 
WHERE IsNull(@someVar,'0') = '0'

Or

Code: 
WHERE LEN(@someVar) = 0
 
Sort by date Sort by votes
This is NOT an EMPTY string :)
This is a string that is NULL. What if you have:
@someVar = ''

So if you want to test for EMPTY and NULL strings use this:
Code: 
IF ISNULL(@someVar,'') = ''

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

FranS37
  • Locked
  • Question
The below SQL strings together data
Replies
5
Views
61
FranS37
FranS37
bmacbmac
  • Locked
  • Question
Fill empty row with 1+ data from row above
Replies
2
Views
60
johnherman
johnherman
Iamthestig
  • Locked
  • Question
Using MAX DATE with Empty Space 2
Replies
5
Views
42
gmmastros
gmmastros
Halliarse
  • Locked
  • Question
Updating / Inserting to an empty table using a 2nd table as a key 1
Replies
10
Views
40
Halliarse
Halliarse
Tarnish
  • Locked
  • Question
empty string in access null error in sql server
Replies
2
Views
33
Tarnish
Tarnish

Part and Inventory Search

Sponsor

Back
Top