Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[ozmael]

I've got a calculated field called 'Name (Full)':

[Name (Base)] [[Mix Name]]

where 'Name (Base)' and 'Mix Name' are user fields. I'm trying to get Name (Full) to look like:

Proud [Babylon 2005 Remix]

This works if there is a value in the Mix Name field but when their isn't a value I get:

Proud []

Is there function or other way that I can remove the double square brackets when there isn't a value in the Mix Name field?

Regards,

[marko]

[name (base)] if(isempty([mix name]),,[[mix name]]

official database expressions page