You can use COALESCE:
SELECT COALESCE(value, 'No value entered')
FROM meta_data
It is important to note that COALESCE returns the higher precedence data
type from the parameters expressions, so this will work fine with character
columns but you will get conversion errors with numeric data types that have
higher precedence. See the example below:
SELECT COALESCE(value, 'No value entered')
FROM (SELECT 10.5
UNION ALL
SELECT NULL) AS T(value)
To fix you can cast the numeric value to character data type:
SELECT COALESCE(CAST(value AS VARCHAR(10)), 'No value entered')
FROM (SELECT 10.5
UNION ALL
SELECT NULL) AS T(value)
HTH,
Plamen Ratchev
http://www.SQLStudio.com