General information
Category:
Coding, syntax & commands
Title:
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only