Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
This is my script. Here, Fields in NAME are displayed in Lower Case and ID in upper case. I want both of them to be displayed as Lower case. How can I do it??
"NAME"&'-'&
Applymap('MAP',ID) as Location#1,
Thanks in advance
May be this
Lower("NAME"&'-'&Applymap('MAP',ID)) as Location#1,
Thanks...It works but I want First Letter of the fIeld to be capital . How can I do it?
Try Capitalize then
Capitalize("NAME"&'-'&Applymap('MAP',ID)) as Location#1,