how can i write:

#myquery.NumberOf_Target#<br>#NumberFormat(myquery.Views_Target,",")#

in mysql, i tried but i am getting is NULL

concat(ISNULL(NumberOf_Total || 0) || ' ' || Views_Total) as total

if anyone asks me about the parameters, i used the set parameter of mysql to set the concationation to

||

anyone can guide how can i write the CF based in mysql, i tried by my try is not right, i am on mysql 5.6

Maybe try switching the ISNULL() to IFNULL()?

concat(IFNULL(NumberOf_Total || 0) || ' ' || Views_Total) AS total