>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.
NVL()
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California