Please help to write the SQL query in a more cleaner way...
CASE ISNULL(TCBOV.cboValueName, '') WHEN '' THEN ''
You don't have to use a CASE statement for this, just a ISNULL or COALESCE within the SELECT.
SELECT ISNULL(TCBOV.cboValueName, '')
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **