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

SQL Server ISNULL() equivalent

Status
Not open for further replies.
dand11

dand11

Programmer
Joined
Jun 24, 2008
Messages
63
Location
US
What is the MySQL equivalent to SQL Server's

IsNull(Field,'')
 
Sort by date Sort by votes
Found it:


IF (ISNULL(field),'',field)




 
Upvote 0 Downvote
Will do. Thanks r937
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soushi01
  • Locked
  • Question Question
MySQL replication slave server re-sync issue
Replies
0
Views
440
soushi01
soushi01
Colin Burton
  • Locked
  • Question Question
Sending A a video clip to either a web server or MySql Database
Replies
2
Views
499
Colin Burton
Colin Burton
dylim
  • Locked
  • Question Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
1K
dylim
dylim
BJZeak
  • Locked
  • Question Question
need help with .sql insert statement
Replies
1
Views
405
spamjim
spamjim
AM_WG
  • Locked
  • Question Question
I need some help with SQL
Replies
13
Views
902
AM_WG
AM_WG

Part and Inventory Search

Sponsor

Back
Top