Upper Case and Lower case

[Anonymous]

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

[sunny_talwar]

May be this

Lower("NAME"&'-'&Applymap('MAP',ID)) as Location#1,

[Anonymous]

Thanks...It works but I want First Letter of the fIeld to be capital . How can I do it?

[sunny_talwar]

Try Capitalize then

Capitalize("NAME"&'-'&Applymap('MAP',ID)) as Location#1,