Displaying JavaScript string obtained from DB as empty string when equal to null [closed]

Question

I am using Ajax where the server queries a database using SELECT someColumn FROM someTable, returns someColumn to the client, and the client updates an element using $('#someElement').text(someColumn);

Works great unless someColumn returns null, in which the page displays "null" instead of my desired empty string. Originally, I was dealing with this at the database level using SELECT COALESCE(someColumn,''), however, am considering changing to the client level using $('someElement').text(someColumn==null?'':someColumn); I am sure there are other solutions as well. What is the best practice method to display null as nothing?

Answer 1

You could try

$('#someElement').text(someColumn || '')

Edit

Will not work if someColumn is a numerical value and has a value that should be displayed, but evaluates to false. But it should work with string values.

Answer 2

Maybe you should try;

$('someElement').text(someColumn===null?'':someColumn);

Just to check the two are the same type.