Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Best practice for concatenating with null character fields?
If I was wanting to concatenate two character fields and one of them could potentially be empty, what code can I use for that? I have worked with this:
allt(address1)+IIF(!empty(address2),address2,'')
Is there any simpler code that you can use? That is quite simple itself, but If you have a long concatenation, your code gets quite long.
Thanks.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement