StrConv Query

[CP611]

I have written the query below, it combines the data in the column 'Address' and 'Address2' with a pipe in the middle. I've added a StrConv Function to ensure that the new address is capitalised. However, it only capitalises the section before the pipe and not after, e.g Smith Cottage|london

ADDRESSLINE1: StrConv([Address] & "|" & [Address2],3)



Any ideas on how to make it add capitals to the other part as well?!

Thanks

[isladogs]

Use StrConv on both sections separately

ADDRESSLINE1: StrConv([Address],3) & "|" & StrConv([Address2],3)

[CP611]

That worked, perfect thank you!