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 gkittelson 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
Jun 24, 2008
63
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
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top