How do I properly use this function in an SQL query. This is how I'm doing it:

SELECT EVENTID, USERNAME, IFNULL(COMMENTS, "") FROM EVENTS;

What am I doing wrong?

Seems correct to me, are you getting any errors? What version of mySql are you running?

I'm running the ODBC connector 3.51 and the error I'm getting is as follows:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/manageevents.asp, line 35

And here is Line 35:

strComments = adoRS("COMMENTS")

Try this:

SELECT EVENTID, USERNAME, IFNULL(COMMENTS, "") as COMMENTS

got it, I was using double quotes instead of single, and no AS columnname

SELECT EVENTID, USERNAME, IFNULL(COMMENTS, "") AS COMMENTS

its the default syntax of if condition in mysql